All Questions
57
questions
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
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
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
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
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
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
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
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
1
vote
1
answer
3k
views
Delete Specific Rows from Excel from a List of Row Numbers
I have a worksheet with 83,188 rows and 4 columns of data.
I have another worksheet that has a list of row numbers (eg 18751, 9127, 696, and etc) that signify the rows I would like to delete from the ...
- 13
-1
votes
1
answer
81
views
I have a large worksheet with many columns. How do ! find specific columns - headers- and their contents and bring them to the beginning of the sheet?
I have a large worksheet with many columns. How do I search specific columns return them to the beginning of the same sheet from B1?
I am using this for an automated weekly task that does not have a ...
0
votes
1
answer
189
views
VBA to perform multiple formula and display only final result
i have a code, and i dont want the intermediate value to be displayed in excel sheet. Below is the example, i just want the final cell AM12 and i dont want the intermediate results to be printed in ...
- 21
-1
votes
1
answer
131
views
Unable to see the cells in the Excel workbook
I am unable to understand this worksheet which was written by someone else. There are certain columns which are not visible unless activated. This activation occurs when I change a value in particular ...
- 1
0
votes
0
answers
100
views
Macro validation and conditional check
i have below excel where i want to do data validation for ColumnName1 ColumnName2 ColumnName3 & ColumnName4 and as well check the condition if ColumnName6 = ColumnName7 && ColumnName5 = ...
- 95
0
votes
1
answer
278
views
Excel VBA - Copy Rows by Unique Value in Column A
I have managed so far to pull all my data from different sources into a “Master List”. From here I would like to pull all rows with matching values from column A into its own sheet.
I.E. All rows ...
