alphabetize sheet.

[monching]

hi, i have an excel file with about 50 sheets of my clients name and i wonder how can i alphabetized them so that i will have no hard time finding my clients sheet, thanks.

[monching]

i named my file with the last name of my clients and now i have to spend more time finding them for a name, can someone help me on how can i alphabetized my worksheet in a single file so that it'll be easier for me to find the sheet that im looking for?, thanks.

[Leith Ross]

Hello monching,

Welcome to the Forum!

Here is macro you place in your workbook to put your sheets in ascending alphabetical order. The instructions on how to add and run the macro follow the code.

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Sincerely,
Leith Ross

[monching]

hi leith, thanks for your help, looking forward for more assistance from this site, i appreciate your kindness.