Work Sheets

External Since: Jul 06, 2007 Posts: 1

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!

External Since: Apr 06, 2006 Posts: 693

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.
--
Regards |:>)
Bob Jones
[MVP] Office:Mac

"Wills" <Wills RemoveThis @discussions.microsoft.com> wrote in message
news:AC92420F-8869-4BC9-A7DF-1AC83BDF52AE@microsoft.com...
> 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!