How do I alphabetize an entire workbook? (9 Sheets)

  • Thread starter Thread starter Guest
  • Start date Start date
I am trying to alphabetize information in column A on 9 sheets. Thank You!
Click to expand...
If your data will fit in a single column:

Option 1: Merge the data into one sheet.

If not:

Option 2: Use VBA to write your own sort routine. The easiest way
would be to move all the data into a single array, use quicksort to
sort the array (search the google.com archive of the XL newsgroups for
a sort routine) and put the sorted data back into the multiple
worksheets.

Option 3: Move the data to a program that supports the necessary number
of rows, MS Access for example.

Personally, I'd go with option 3 -- and *not* move the data back into
XL.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Highlight column A and all the other columns that have data
Click on Data - Sort - select column A for the first sort then decide
whether or not the first row is a header. Do you want the first row sorted
with the data?
 
Back
Top