sort a [group] of sheets

[rbraxton]

Is it possible to sort a [group] of sheets?

Thanks,
Rob

 

[tusharm]

What does that mean?

 

[rbraxton]

sorry, i wasn't very descriptive...

I have like 200 sheets in a workbook and I'd like to reorganize them in alphabetical order.

Also,
Is there a way to quickly 'Go to...' a sheet without scrolling through a list to find the sheet?

Thanks,
Rob

 

[Norie]

Rob

Do you mean sort the order of the sheets?

Or sort the data in every sheet?

If you right click the navigation buttons in the bottom left you'll get a list of worksheets to navigate to.

 

[tusharm]

To create a list of navigable worksheet names, check
Table of Contents
http://www.tushar-mehta.com/excel/software/maketoc/index.html

For an add-in that supports workbook navigation (in addition to right-clicking the VCR controls near the bottom left of the XL environment) see
Workbook Navigator for Excel
http://www.tushar-mehta.com/excel/software/utilities/wb_nav.html

To actually sort the sheets see Chip Pearson's
http://www.cpearson.com/excel/sortws.htm

sorry, i wasn't very descriptive...

I have like 200 sheets in a workbook and I'd like to reorganize them in alphabetical order.

Also,
Is there a way to quickly 'Go to...' a sheet without scrolling through a list to find the sheet?

Thanks,
Rob

 

[rbraxton]

Thanks tu!

(that's what I was talking about...sorting sheet names)