Worksheet tabs
 

I have a workbook with several tabs that have been renamed with #s
corresponding to what is in each worksheet. Is there a way to sort the
worksheet tabs and thus the worksheets form lowest number to highest number
without dragging each tab one at a time to its correct place? Thanks.

Worksheet tabs
 

See:

http://www.cpearson.com/excel/sortws.htm
--
Gary''s Student


"Dani" wrote:

I have a workbook with several tabs that have been renamed with #s
corresponding to what is in each worksheet. Is there a way to sort the
worksheet tabs and thus the worksheets form lowest number to highest number
without dragging each tab one at a time to its correct place? Thanks.

Worksheet tabs
 

Or use the free Excel add-in "Excel Extras" to sort sheets ascending
or descending. It does other nice stuff too.
Download from ... http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA


"Dani"
wrote in message
I have a workbook with several tabs that have been renamed with #s
corresponding to what is in each worksheet. Is there a way to sort the
worksheet tabs and thus the worksheets form lowest number to highest number
without dragging each tab one at a time to its correct place? Thanks.

Worksheet tabs
 

This link do not work anymore.
Anybody has this sorting Add-in by any chance?

Thanks,

Cem

"Jim Cone" wrote:

Or use the free Excel add-in "Excel Extras" to sort sheets ascending
or descending. It does other nice stuff too.
Download from ... http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA


"Dani"
wrote in message
I have a workbook with several tabs that have been renamed with #s
corresponding to what is in each worksheet. Is there a way to sort the
worksheet tabs and thus the worksheets form lowest number to highest number
without dragging each tab one at a time to its correct place? Thanks.

Worksheet tabs
 

Create your own add-in and use the code from Chip Pearson's site.

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


Gord Dibben MS Excel MVP

On Wed, 23 Dec 2009 13:01:01 -0800, Cem
wrote:

This link do not work anymore.
Anybody has this sorting Add-in by any chance?

Thanks,

Cem

"Jim Cone" wrote:

Or use the free Excel add-in "Excel Extras" to sort sheets ascending
or descending. It does other nice stuff too.
Download from ... http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA


"Dani"
wrote in message
I have a workbook with several tabs that have been renamed with #s
corresponding to what is in each worksheet. Is there a way to sort the
worksheet tabs and thus the worksheets form lowest number to highest number
without dragging each tab one at a time to its correct place? Thanks.