Sorting Excel SHEETS

A

Andrey Batashov

Hey friends,

Does anyone have a clue on how to sort Excel SHEETS by
their name? Let's say i have a Workbook with 20-30 sheets,
each sheet has unique name. Sheets are entered in random
order, but in the end I have to sort them to have them
visually on the screen sorted by their names (not system
names, but those I enter myself): first "08934",
then "A235", then "BKJHK", then "Z-09345" etc...

Please answer into the newsgroup and drop me an e-mail at
(e-mail address removed)

Thanx in advance!!!
 
P

Paul B

Andrey, have a look here http://cpearson.com/excel/sortws.htm

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 

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

Excel VBA Macro to do this? 19
Macro to copy portion of each sheet and paste into the first sheet asa picture 1
How to combine/consolidate data 2
Sorting data and searching 5
excel sheet name 2
Many sheets, one DB? 1
How to print two a6 booklets (A5 unfolded) on A4 paper? 3
Find Specific Rows in Range and Create New Tab 18

Top