Can you sort the sheets?

[mike schmidt]

Is there any way to sort or organize or even view the sheets? - except as
lifeless tabs?

I have 150 sheets - i know I need a database instead of a spreadsheet - but
until then.....


Thnaks

 

[J.E. McGimpsey]

Look here:

http://cpearson.com/excel/sortws.htm

 

[Gord Dibben]

Mike

1. Sort.....see Chip Pearson's site for code.

http://www.cpearson.com/excel/sortws.htm

2. Organize.....see David McRitchie's site for table of contents. David also
has code for sorting and manipulating.

http://www.mvps.org/dmcritchie/excel/buildtoc.htm

If you are not familiar with macro and VBA code see David's site to get
started.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

3. View......To see two or more sheets at the same time you could use
Windows>New Window>Arrange

Also if you right-click on the arrows at lower left side of status bar you
will get a list of sheets to select from. Only 16 at a time so your 150 would
take a lot of clicking.

Gord Dibben Excel MVP XL2002