Hi!
I have a list with approx. 60.000 entries (one per row) and one empty row after each letter. Eg:
Adam
Albert
Aston
<empty row>
Barbara
Barbie
Busty
<empty row>
Charles
...
Now, what I would need to do is to cut the rows of all entries which start with the same letter and paste them into a worksheet named after the respective letter (e.g "A", "B", "C", etc.).
Well, since this work is a little tiring, I was hoping that someone could help me with a macro who does that simple work for me, please
Every help is highly appreciated!
Thanks a lot,
A2k
Bookmarks