All Questions
3,386 questions
-1
votes
0
answers
126
views
Looping through a column and using each cell's value to fill in a range of empty cells in adjacent columns
I have a worksheet with 5000+ rows. Some cells in column F are empty and some have formulas. I want my current code to loop through all cells of column F and pull the value found in each to fill in ...
0
votes
0
answers
61
views
VBA code loop through all items in a slicer and print multiple sheets to PDF
I created 6 Excel sheets with pivot tables and charts all connected to one pivot table with a slicer. The slicer is in the sheet "Dashboard 1" and is named "Slicer_EnrollDistrictNumber&...
0
votes
0
answers
26
views
How can I fix issue with ultimaCelula in SAP VBA##? [duplicate]
Can anyone please help me to make this Script to stop when it finds a blank cell in column d ?
Short:
I want this script to open transaction CV01N in SAP, run SAP picking information from column d, e ...
0
votes
2
answers
76
views
Calculate Tax Income with Excel Formula
I am trying to calculate the tax Payable for person A. Formula to calculate in Table 2, cell D12, and calculate from D10. Salary in D10 will change depending on user input.
I have used few formula but ...
- 35
-5
votes
1
answer
105
views
VBA for loop exercise with merged cells
I need to write a VBA script using a loop or a few loops, which in the end will print the data, by debug.print looking like this:
can, kg, green, pea, 24.79
Here is the image of how my sheet looks ...
0
votes
1
answer
40
views
Update notes (comments) looping through range
I have a workbook with several sheets.
The "HVAC TOOL" sheet houses a pricing worksheet for our sales staff.
Each unique equipment type is listed on this worksheet in
Sheets("HVAC TOOL&...
0
votes
2
answers
94
views
vba code to loop thru sheets and rows to get a total count
I have the following code to loop thru the Parts,Pipe and Misc Sheet rows and get the quantities from the RF sheets.
Sub GetQuantity()
Dim ws As Worksheet
Dim x As Long, c As Long, lLastRow As Long
...
- 25
1
vote
1
answer
48
views
Simplifying If Statements Into Loop
I have code that changes the line color in an Excel line chart based on a cell value but would like to simplify it if possible.
This is my code:
Sub colorSegment()
Dim ws As Worksheet
Dim cht ...
- 33
1
vote
2
answers
80
views
Im trying to loop through specific sheets and change values of column A starting from A2
Im trying to loop through specific sheets and within that sheet change the values of column A starting from cell A2 to value 1 and onwards.
For example cell A2=1, cell A3=2 and goes on
This is my code
...
- 11
0
votes
1
answer
52
views
loop through excel raw data file and input them to other excel formula sheet and perform iteration calculation
I have two excel raw data tables called meandiretcion (image1) and meanspeed (image2). I also have another excel file with formula (image3), and the excel formula file has 3 sheet (sheet1, sheet2, ...
0
votes
1
answer
42
views
VBA Copy - Destination to another workbook returns Invalid procedure call or argument
I am looping through worksheets with different data and along with formatting i want to copy the top 3 values from the existing workbook to a summary workbook. The loop works fine without the copy-...
0
votes
1
answer
112
views
Word VBA: How to reference a Named Range/Cell from Excel so it returns the row number
Solution: See Macropod's suggestion for solution & make sure you have CorruptLoad:=xlNormalLoad and not CorruptLoad:=xlExtractData
ExtractData = copies and pastes only the data into another ...
- 5
0
votes
1
answer
49
views
VBA and Combobox values
I have a form with a combo box, and I would like the corresponding values related to the selected ID from the combo box to display in text boxes. The issue is that the text boxes only display the ...
- 1
0
votes
1
answer
50
views
Extract row one by one from excel table, and save each extracted row individually as new excel file using loop
I have one header excel file (header.xlsx) with only one row, and one excel table file (station.xlsx) with multiple rows.
The aim is to extract first row from (station.xlsx), and then append the ...
0
votes
1
answer
68
views
For Loop with and print function
having trouble with a for loop. I effectively have a set of 5 cells then need to go through a loop, which will affect calculations on a different page. Those calculations will give me a range of data ...
