how do I change the order of the workbook tabs?
 

I have established a workbook with 35 tabs. I would like to have the tabs be
in numerical order. I have used numerics to name the tabs, but I did not
enter them in chronological order. Help? Please

how do I change the order of the workbook tabs?
 

Have a look at Chip Pearsons's numeric & alphabetic sorts


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

Mike


"PJW" wrote:

I have established a workbook with 35 tabs. I would like to have the tabs be
in numerical order. I have used numerics to name the tabs, but I did not
enter them in chronological order. Help? Please

how do I change the order of the workbook tabs?
 

That's pretty cool Mike...PJW, if you're not VBA savvy, you can simply click
and drag the sheets in order...shouldn't be too hard with 35 sheets...if it
was 350 I'd try to learn the VBA!! :) Good luck!

"Mike H" wrote:

Have a look at Chip Pearsons's numeric & alphabetic sorts


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

Mike


"PJW" wrote:

I have established a workbook with 35 tabs. I would like to have the tabs be
in numerical order. I have used numerics to name the tabs, but I did not
enter them in chronological order. Help? Please