Excel Worksheets

G

Guest

I have created an Excel Spreadsheet to track share transactions and have worksheets for leach company. How do I sort the worksheets into alphabetical order other than dragging them into the correct order?
 
N

Norman Harker

Hi Diane!

Chip Pearson has some code for this at:
http://www.cpearson.com/excel/sortws.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Diane said:
I have created an Excel Spreadsheet to track share transactions and
Click to expand...
have worksheets for leach company. How do I sort the worksheets into
alphabetical order other than dragging them into the correct order?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Worksheets alphabetical? 1
worksheets in alphabetical order in office 2007 4
how can i re-sort multiple worksheets into alphabetical order 2
Can I quickly split up worksheets into different files? 4
Linking worksheets, rearranging rows. 1
re-arranging worksheets 4
combine worksheets 1

Top