All Questions
Tagged with worksheet-function vba
227
questions with no upvoted or accepted answers
3
votes
1
answer
1k
views
Data on excel from access database based on criteria in excel
I have a MS Access database to which an excel file is connected to view output. MS Query is used to interface and fetch data based on two conditions date & ID. I am unable to specifiy the ...
- 31
3
votes
2
answers
333
views
Excel 2013 VBA programming
I'll start off my saying I'm trying to save time for a family member who is doing this program manually.
Sheet 1
Column A is a start date
Column B is a projected start date
Column E is a Task Name.
...
- 31
3
votes
1
answer
1k
views
excel vba: to export multiple excel sheet into its designated jpg file
I am working on an excel vba command to export multiple excel sheet to its designated jpg file.
I have 16 worksheet in one excel workbook and it would be best to export each sheet into jpg format.
...
- 31
3
votes
1
answer
4k
views
How to have a cell calculate only once
I have cell N29 calculating some values based on streaming data. Once a condition is met in cell Q29, the calculation or final value should be passed to cell O29 and no longer calculate in either cell....
- 31
2
votes
0
answers
332
views
Excel: Multiple Selections in one drop down/one cell possible--perhaps using a listbox?
The current problem I have has to do with tagging multiple categories to an a list of items in Excel. A rough example is shown below, with the second column being the CONCAT column that takes in data ...
- 41
2
votes
2
answers
181
views
Removing Duplicates Across 3K Rows, 9 Columns
I have an Excel 2010 table of 3,800+. I would like to identify duplicates across 6 columns, many with text, some with IP addresses and hostnames, so that accurate data is reflected. I've tried the old ...
- 21
2
votes
1
answer
2k
views
Use Excel to match data from a cell on a worksheet, then copy data from its neighboring column and paste on a different worksheet
I have a spreadsheet with multiple names and phone numbers next to them in each Sheet 1 - Sheet 5.
Each Sheet has about 900 names on column A and their associated phone numbers next to them on column ...
- 33
2
votes
2
answers
10k
views
VBA: How to replace entire Excel cell value basing on its content?
I have an Excel Spreadsheet with some names in a cells. There can be as one name per cell as multiple names in one cell.
For example: Cell A5 contains "Joe", cell BD54 contains "Joe;Harry;Molly", ...
- 31
2
votes
2
answers
1k
views
How to create number +1 from the previous sheet
I want to copy single sheet to multiple sheets in the same workbook with macros,I know how to do it but I still have further question.
I am using formula:
Sub Button3_Click()
Dim x As Integer
Dim y ...
- 21
2
votes
1
answer
265
views
Show (copy) data at "X" time and stop update
I have two sheets.
In the first sheet, cell F4, I have 00:00:00 (countdown). G9, G10 and G11 are cells that receive live data (decimal numbers).
In the second sheet, I have three cells linked from ...
- 21
1
vote
1
answer
82
views
Custom Information Message for user based on another cell value
I am busy with an optimization spreadsheet which needs to display an information message, maybe similar to the Input Message for data validation (but I am open to suggestions). This message will be ...
- 21
1
vote
0
answers
86
views
VBA code to copy data from different works book to specific sheet of master workbook
I have to copy data from 15+ workbooks and combine it into a different master workbook. All these 15+ workbooks are identical and contains a sheet(tab) named 'Comment' and have same header names for ...
- 11
1
vote
1
answer
223
views
Use Cell references within SUM function (Excel)
I am trying to create a function in one sheet, that sums up information on another sheet and as I will be running this multiple times with different datasets, I need this to be flexible. I am trying ...
1
vote
0
answers
12
views
How can I generate a multi column sorted list in Excel based on data pasted into another sheet?
Okay, so I can't unfortunately go into too much detail due to the sensitive nature of the data, but the short of it is that I've got a table I paste into "Source" that I'd like to have two ...
- 111
1
vote
0
answers
69
views
How do I extract design information from a pivot table in an external worksheet (properties) (Excel)
I am teaching a course in Microsoft Excel, using Excel 2019. As part of an exam in this course, I ask students to create pivot tables. I will then need to grade these exams.
Each student submits an ...
- 36