All Questions
Tagged with worksheet-function vba
575
questions
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 ...
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 ...
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 ...
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
...
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 = ...
0
votes
0
answers
142
views
Highlighting duplicates in Excel with VBA, multiple sheets
I have a workbook set up with a sheet for every month and then a summary sheet, so 13 sheets total. Each sheet, other than my summary page, have two sets of tables set up. A table for each week in ...
1
vote
1
answer
40
views
Formulas corresponding to the correct table in my sheet, vba. Multiple tables across multiple sheets
I am setting up a cycle count sheet using VBA. I am having trouble with the formulas in my tables only referring to the first table in the sheet for the input values.
For example, I have 4 tables per ...
1
vote
3
answers
139
views
Convert an Excel table from one structure to the other
Original table
I have this table in Excel or LibreOffice.
Unit number
Type
Name
1
Object
Top
1
Object
Bottom
1
Object
Left
1
Object
Right
1
Object
Back
1
Object
Front
1
Property
Right-Fixed
1
...
-1
votes
1
answer
272
views
VBA Code to hide rows on multiple sheets
Very new to this so. Is there any way to have the option cell K473 be on tab 1 and change the hidden rows on tabs 2 to 11? The below works perfectly on a single sheet, but would like to have the ...
0
votes
1
answer
541
views
Creating a VSTACK'd array from a changing list of spilled references
I am working on a project that requires a large 'pool' of data to pull from and sort from. To keep the workbook efficient, the data is kept in sets of SPILL's, as pulling a raw selected range for the ...
2
votes
1
answer
50
views
Separately color all rows for unique clients listed in one column
I am a relative Excel noob, and to that end, forget about Excel macros. I'm here because this seems to be where the GOATs congregate, and I really need some help.
I have an enormous data set that ...
-1
votes
1
answer
283
views
How can I use Excel to replace values in a comma separated list with values in another cell?
I have a lookup table that looks like this:
ID | SKU
1 | 5123
2 | 1238
3 | 5812
And another table that has a comma separated list of SKU:
SKULIST
5123, 1238
5812, 5123
How can I add a column that ...
0
votes
5
answers
160
views
How to do this very specific concatenation and transform an array to list using Excel?
First off, sorry for any grammatical errors, I'm not a native English speaker.
My problem is as follows: I have a very big dataset which contains populational data of a given city (row) in a given ...
0
votes
2
answers
35
views
Excel: is there a formula/code I can use to paste specific values based on a dropdown value?
I’m a new user looking for help on an Excel formula/macro code.
To demonstrate my scenario, let’s say I have a drop down list with values of “Breakfast, Lunch, and Dinner”. If the user selects ...
1
vote
1
answer
104
views
Need a VBA Solution - Clear contents of 7 cells to the right of cell
I have a document where I need to look for a specific text and clear all text in the cells to the right of it. I don't want to delete the cells just clear them out. There are a total of 7 cells next ...
0
votes
1
answer
4k
views
How do I add the median and average to a graph?
I have this graph which was composed from a dataset. I want to add a horizontal line at the Median (0.97), and a separate horizontal line at the Average (1.16). I need the horizontal lines to ...
-1
votes
1
answer
205
views
Populate cells on one sheet from data on another based on a user-defined variable that dictates the range
I'm trying to build an inspection report template for solar installations and am somewhat new to complex Excel usage (and brand new to VBA), but very comfortable with programming and learning fast!
...
0
votes
2
answers
259
views
How to properly and efficiently query Lots of data from SQL Server putting it into specific cells?
Recently I was asked to make a real-time project in Excel which evolves huge amount of data.
I have this data stored in SQL Tables and managed to successfully bring it into Excel.
SQL Table on Excel:
...
0
votes
0
answers
876
views
How do you get the raw data of an Excel file?
The European Union (EU) provides an Excel file that has data on trade between various countries. Their Excel file, however, only shows data between countries based on a filter function. It seems they ...
0
votes
0
answers
68
views
How to cut row from sheet1 and paste onto sheet2 - excel
i need help. I have multiple sheets.
Rejected Candidates
Interested Candidates
Candidate Track
Onboarding Track
Now I have these formulas:
=CHOOSECOLS(FILTER(Interested_Candidates,...
0
votes
1
answer
751
views
Excel VBA - Copy data from multiple sheets into a table
I'd like to be able to copy data from multiple sheets into a table without deleting the table's formatting.
The data being copied from each sheet will always contain 6 columns
But the number of rows ...
0
votes
1
answer
117
views
look for empty cell between non empty cells in one row and then put 0
enter image description here enter image description here
A B C
abc 30 40
def 4646
ghi 45 3234
So, I want to write a macro code where it takes all three columns into consideration at once....
0
votes
1
answer
372
views
Excel: Extracting the row name and column name corresponding to the MAX value in my DataTable
In cell K1=MAX(J7:AM36)
I have the maximum value of the data table, I want to extract the corresponding StopLoss% ( This is my column headers, they are %) to Cell K2 and also my TakeProfit% ( This is ...
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 ...
1
vote
0
answers
51
views
Creating .txt files from excel columns with description [closed]
I am trying to create .txt files that have the following:
Txt file name would be cell(A1)
Content of the txt file needs to be the content of cell (B1)
Repeat throughout the column
I am new to VBA and ...
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 ...
0
votes
0
answers
59
views
Multi Sheet Inventory that allows for an ordered quantity to be entered, once product delivered, the stock column updates to existing + ordered
I've been breaking my head over this one.
I have an inventory that has 10 sheets and a 500 different items. Stock entry To enter data, you can select the manufacturer (Lieferant), the page on which ...
0
votes
2
answers
555
views
Transpose Group of Rows to Single Row | MS EXCEL
I need to Transform Some Uneven Group of multiple rows to single row
I Tried to Extract the Required data from multiple row to multiple Column. But all data placed under different Rows (same as input ...
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 ...
0
votes
1
answer
104
views
When an Ecel workbook with LAMBDA function must be saved as macro enabled?
I am looking for the LAMBDA function to replace the below VBA function for evaluating strings:
Function Eval(Ref As String)
Eval = Evaluate(Ref)
End Function
I made a minimum function in the Name ...