Hi All,
New to coding, looking for a way to do a loop I guess is the best way.
I have column H with 7,000 lines of ID's.
I need to copy and paste those lines 6 times.
Then I sort them and on column O write numbers 1-6 . The loop is for those 7000 Ids to have one number each.
Samething on column N (this time with text)
End when there is no more text on column H.
Example:
H N O
ID1 A 1
ID1 B 2
ID1 C 3
ID1 D 4
ID1 E 5
ID1 F 6
ID2 A 1
ID2 B 2
ID2 C 3
ID2 D 4
ID2 E 5
ID2 F 6
ID3 A 1
ID3 B 2
ID3 C 3
ID3 D 4
ID3 E 5
ID3 F 6
I would like to thank anyone who can help in advance! I'm desperate! Thanks!
Bookmarks