Hi,
In column A I have a lot of names (occuring on every 5th row). They're not sorted.
All these names I want to list and sort in column G (without empty rows).
Please see example attached.
Any suggestion for how to do this with a macro?
Hi,
In column A I have a lot of names (occuring on every 5th row). They're not sorted.
All these names I want to list and sort in column G (without empty rows).
Please see example attached.
Any suggestion for how to do this with a macro?
Why do you need a macro for it?
You just sort the data as is and it will remove all the blanks for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thanks for your reply Arlette,
Yes. I think I do. Because this is just a part of a bigger dynamic document, and I need to sort the data now and then in a quick operation. Like just click on a button for instance.
Here it is - I just recorded the steps and then just modified it a little to remove the unwanted statements -
Please Login or Register to view this content.
Exactly what I was looking for!
Thanks Arlette!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks