I have a long list of "LOTS" as in col A. Now I need to repeat them into two rows for each "LOT" as in col C.
They are not necessarily sequential.
Thanks again for all your help.
I have a long list of "LOTS" as in col A. Now I need to repeat them into two rows for each "LOT" as in col C.
They are not necessarily sequential.
Thanks again for all your help.
The easy way would be to copy the list and paste it below the original list. Then sort it ascending.
If you really need a macro, record the actions as you do them. It will need minor tweaks to cater for different length lists.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Do you really need a macro, this can be easily done with a formulaFormula:Please Login or Register to view this content.
Marked solved? No comment? No feedback? Nothing?
I'm sorry, thought I had done that. The INDEX formula worked great.
Your solution worked as well but didn't sort as well (1,10,11 etc.).
I did add reputation and thanks to both of you.
Thanks again.
My bad. The rep is there, thank you for that. I just get frustrated when I spend time on a solution and do not find out if it helped.
Glad you have a solution, albeit not mine. When Fluff says, "easily done with a formula", I would never have come up with that.
Glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks