Needs Help with Cell Value Loop
Hi! :)
I need advice about this code.
I want to take the value of G1 and insert it in H2 along with some other text. This is continuous over every 11 cells, that's why there is a step 11.
As of now, it does not work correctly. I have attached an example workbook you can use. Any help is appreciated :)
Book1.xlsm
I need advice about this code.
I want to take the value of G1 and insert it in H2 along with some other text. This is continuous over every 11 cells, that's why there is a step 11.
Dim Range, Item As Integer
For Item = 2 To 135 Step 11
For Range = 1 To 135 Step 11
Counter = Cells(Range, 7)
Cells(Item, 8) = Counter & "(Sales Revenue in Thousands)"
Next
NextAs of now, it does not work correctly. I have attached an example workbook you can use. Any help is appreciated :)
Book1.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER