General discussion
| Thread display: Collapse - |
All Comments
Back to Community Forum
0 total posts
(Page 1 of 1)
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Excel problem 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.