General discussion
-
Topic
-
Excel problem VBA/macro
LockedI have a specific problem concerning VBA/macro:
I need a macro that reads the contents of 2 cells A1 and B1 (both numeric) then creates new string values by combing these values and fills in new these stringvalues in the A-column starting in cell A2 and continuing downwards the number of times equaling the number from cell B1.
The stringvalue should be like this THE_CONTENT_FROM_A1 +’/’ + the stringvalue from 0 to the value from cell B1 – increasing with ONE from one row to the next:
i.e:if A1=Oslo345 and B1=5
the result:
B2=Oslo345/1
B3=Oslo345/2
B4=Oslo345/3
B5=Oslo345/4
B6=Oslo345/5Anyone ?