Discussion Locked

Excel problem VBA/macro

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I 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/5

Anyone ?

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.