All Questions
Tagged with worksheet-function vba
575
questions
2
votes
1
answer
9k
views
How can I refer to an Excel worksheet by index rather than name?
Woe is me, I have an Excel workbook with a gazillion sheets; each with its own unique, non-sequential name. I want to refer to these sheets using their indices rather than names. How can I do that?
- 9,854
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....
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", ...
CommunityBot
- 1
0
votes
2
answers
6k
views
How can I make a volatile Excel formula static, specifically a formula containing the TODAY function?
I have a task log that I created at work to prioritize my daily to-do's.
In one column I've added a formula to automatically calculate Covey's quadrant numbers based on whether or not I've assigned ...
- 18.3k
0
votes
2
answers
5k
views
How to VBA update a cell value based on another cell
I've looked all over stack exchange and have not seen exactly what I'm looking for. I have an extensive list of some items that need constant calibration at different dates and intervals, and what I'm ...
CommunityBot
- 1
0
votes
2
answers
5k
views
How to modify these VBA codes to save excel sheet in excel format (.xlsx)?
I have added a button in excel sheet and now when I click that button it saves the sheet at specific path with specific name but in pdf format.
I want to save this sheet simply in excel format (....
CommunityBot
- 1
1
vote
1
answer
6k
views
How to remove hidden character in excel?
I have an excel table like the following, I want to delete the blank cell by:
Find & select -> go to special-> blanks
then ok, but "no cells where found" appears,
after I tried pressing the ...
CommunityBot
- 1
0
votes
1
answer
43
views
Excel: Worksheet.Calculate causes UDF to run infinitely
I have written a udf returns an array that is inserted at the cell location.
the udf can be long running as it reaches out to a rest service to fetch data from a database. so i added a button on my ...
- 9,494
0
votes
1
answer
4k
views
Enter time duration in Excel in mm ss format (without hours and colons)
Enter time date in excel in mm:ss format(just buy inputting numbers without the colon : and 0: hours in front)
Hi, I'm working on a project and need to calculate the number of minutes and seconds ...
CommunityBot
- 1
0
votes
0
answers
43
views
Linking columns on different sheets
I'm very new to VBA coding (only dabbling for this specific project), so I would really appreciate any advice on an issue I'm having. I'm attempting to independently link multiple column ranges on ...
- 1
0
votes
2
answers
5k
views
How do I stack multiple columns into one column in Excel 365 Mac
I currently have my data in different columns after using a Text To Columns feature. Now what I want to do is to put them all into one column. Can you please advise what formula to use or is there a ...
CommunityBot
- 1
1
vote
1
answer
4k
views
VBA - Copy, Paste then delete from old sheet
I have a worksheet that allows a user to pastes data in and then paste it into a hidden sheet in the workbook that drives a pivot table. This is done by command button.
My code selects data in the ...
CommunityBot
- 1
0
votes
0
answers
24
views
Insert MODE.SNGL into a conditional formula pulling data from one worksheet to another
Windows 10
Excel 2019
I have a workbook with two worksheets, Product Data and Product List.
The data in Product List is generated each time the formula I am looking for is run.
The number of products ...
- 43
0
votes
1
answer
57
views
Excel VBA - Looping an IF( & VLOOKUP( starting with a partial string
Good day to an amazing community,
I am trying to develop a macro to loop through two arrays. Here is an example of how the data is set up:
Raw data is found in C4:C1500
$ data is found in D4:D1500
...
- 19.1k
0
votes
1
answer
94
views
Replace with wildcards in Excel or batch edit some wrapping formula
I'm only trying to delete some CONCATENATE() function from some formulas in Excel.
What I have; here 'Something' could be a lot of things (digits, <, >, texts, etc…
CONCATENATE("Something = ...
- 56.1k