Work Sheets

[Wills]

Is there a way to ask a Work book to arrange it's Work sheets in Numerical
order?

I created a Work Book for Inventory purposes, with a start page. I recently
added about 100 new items and linked them departments. On the start page I
keep departments together numerically, but the Work sheets are not in that
order. I can move them around manually but it will take some time! Is there
a way to highlight the tabs and then have them re-arranged in numerical order?

All the Work Sheets are numbered according the their respective Departments!

 

[CyberTaz]

Sorry... Not a feature the program offers on Mac or PC. There *may* be a way
to do it with VBA, but I would expect it to be rather complex.

 

[CyberTaz]

I knew it was out there somewhere... perhaps this will be of use:

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