All Questions
Tagged with worksheet-function vba
575
questions
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 ...
