General discussion

Locked

Excel problem VBA/macro

By haarsaker ·
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 ?

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Community Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums