on worksheet 1, I have 100 unsorted rows with:
First Name | Last Name | Phone Number
I would like to have this formatted on worksheet 2 with a specified (via a variable) number of rows and columns in alphabetical order by FirstName LastName | Phone Number.
So the output would be something like:
NAME | PHONE | NAME | PHONE | NAME | PHONE --> through column break
Abe Smith | 12345
Adam Johnson | 12346
...
...
...
through row break.
So in above example, columns would be 6 (NAME|PHONE|NAME|PHONE|NAME|PHONE) and rows might be 36.
The First 2 columns might have data for names starting with A-F, the next might have data for G-J, depending of course on the names in the original unsorted list of worksheet 1.
Can someone help me with this?
Bookmarks