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!