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 ...
- 101
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
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
...
- 1
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 = ...
- 101
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 ...
- 13
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 ...
- 13
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
...
- 270
-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 ...
- 1
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 ...
- 23
-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 ...
- 101
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
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 ...
- 13
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 ...
- 129
-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:
...
- 13
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 ...
- 101
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,...
- 9
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 ...
- 1
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....
- 1
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 ...
- 3
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
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 ...
- 1
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 ...
- 1
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 ...
- 115
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
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 ...
0
votes
1
answer
260
views
Keep VBA code working if I run it from a button in another sheet, or replace the code with formula
I'm trying to sort the date in an excel sheet, I want to click on a button to do this, but button is not at the same sheet
I assigned the macro in a button in the same sheet, it worked very well, but ...
- 45
0
votes
2
answers
1k
views
Create a macro that automatically updates time & date but doesn't change when I type in other cells
At my job we have this CSR sheet that we use for self service.
The idea is you fill each row as a call is taken every day
and then email it to our boss.
I put an example of the sheet at the bottom.
...
-2
votes
1
answer
421
views
Consolidate first letter in single cell [duplicate]
Have been looking for a while and can't find a solution.
I am trying to find a way to consolidate the first letter in single cells using a formula/vba. I am new to excel and vba but slowly learning.
...
- 1
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 ...
0
votes
2
answers
757
views
Merge Rows and Sum Single Value in Excel
I want to merge rows with mostly similar data but sum their quantity values, using the unique "id" value while keeping the rest of the data in the row intact.
The raw output looks like this:
...
- 3
0
votes
1
answer
461
views
VBA code to auto hide rows based upon text in cell A1
I cannot seem to get my code for this sheet to work properly.
I have code in there functioning fine which will hide rows based upon whether cells in a range are empty.
However I would like to ...
- 1
0
votes
2
answers
2k
views
Move data from multiple columns into one and remove duplicates
I currently have a situation wherein I require the unique data from multiple columns to be moved/identified in one single column.
The data currently looks like this:
Apple
Microsoft
Dell
U.S
U.S
...
0
votes
0
answers
232
views
Count dependents in other sheets VBA
I want to count the number of dependents of a cell in same sheet as well as in other sheets using VBA.
I have used below code and results are in the picture.
enter image description here
Sub tst()
Dim ...
- 55
0
votes
0
answers
70
views
How to Insert an autofilter if cell in row range contains value
I'm trying to create a function that inserts a filter within a cell range if a cell contains a value
Here is my code:
Sub FilterFunc()
Dim i As Long, lastCol As Long
Dim rng As Range, cell As ...
0
votes
1
answer
385
views
Excel - Transfer inputs from one sheet to another sheet to do calculations and returns a value
I'm just wondering if I could link the two sheets in Excel where you can transfer inputs from Sheet 1 to Sheet 2 to do some calculations and then return a value back to Sheet 1.
See the attached ...
- 1
0
votes
1
answer
71
views
How to sort 3 unusual type of dates in Excel?
I have 3 types of dates in my excel files. These dates include the above : Q (quarter), Apr (Abbreviation or abbreviated name of the month), April (Full name of the month). These are combined with the ...
- 19
0
votes
1
answer
296
views
How to change order of values in Excel?
I want to edit arrangement of values entered in a column and separated by a semicolon.
For example this is a very small sample of my files:
And now i want to convert to this:
Note:
Always the first ...
- 19
0
votes
1
answer
948
views
Excel: How do I list all the values in that column based on dynamic column header name?
This is my scenario, The "Creative Direction" Sheet is a template that I give to my clients. When it is returned to me, they've added extra columns in between of my columns. It takes a long ...
- 1
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
1
vote
1
answer
710
views
In-Cell Calls to Excel VBA Functions Not Updating
I am having difficulty with a VBA function called from an Excel cell not automatically updating or updating manually with F9, Shift+F9, etc.
I'm Using "Microsoft® Excel® for Microsoft 365 MSO (...
- 113
0
votes
1
answer
752
views
Remove formula in cell using vba
I have made two vba codes.
For doing round off on selected cell. Working fine
For undoing round off on selected cells. This has a little issue. After i do this it make the cells isformula true. But ...
- 55
0
votes
0
answers
39
views
How to add a cell automatically to a sheet when I add another cell on another sheet?
I have some time series data, so I will add one new data point to one excel sheet for several sheets in an excel file, then I also need to add all these new data point to another sheet, so that I can ...
- 101
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
0
votes
1
answer
142
views
Combine cells value with the header and ignore the blanks
I want to combine the fixed row value with diffrent column value but by skipping blank cells. I've a code but it is not working. Please suggest
Public Function SuperJoin(r1 As Range, r2 As Range, ...
- 1
0
votes
1
answer
27
views
Formula won't calculate or increment
In the following code, my formula apply as text and won't calculate. Also, Autofill won't increment cell number. I also tried with ActiveCell.Value
Dim RowCount As Variant
Dim VRowStartNoMember As ...
- 3