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

I am trying to alphabetize information in column A on 9 sheets. Thank You!

In article ,
says...
I am trying to alphabetize information in column A on 9 sheets. Thank You!

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?

"MrsB" wrote:

I am trying to alphabetize information in column A on 9 sheets. Thank You!