Excel Sorting Help

[Eleischner]

If I have a large number of worksheets, for example named bob, john, clive, steve etc. is there a way anyone knows of to sort the actual sheets in a workbook alphabetically, I cant fin a way to do it.

Thanks in advance.

[Woz]

Not that I know of, I usually just move the sheets manually. Bit of a pain if there are a number of sheets, but, ...

Mind you, I would be very happy if someone could prove me wrong.

Onya
Woz

[Eleischner]

yeah I would do it manually but there are 100+ sheets on it so Im a bit stuck in that respect. I too would love someone to prove you wrong :) Maybe theres a macro or something around you can use for it.

[GilbertZ]

Is that your only goal or does this tie in with your data too? No way of doing exactly what you asked that I know of, however, if you have the name of the sheet show up in one cell of the spreadsheet, in the same place for every page, you could associate them all together, build a pivot table and then a drop down box around it on a presentation sheet, allowing you to access each report quickly and easily..

I haven't done a pivot table in years, but it's one unique feature that excel does that I have not seen any other type of spreadsheet or database offer a tool for, and it's just excellent for managing multiple sheets of data.

Play around with it and let me know if it worked!

[Eleischner]

Its records for employess, each sheet is a different employee's information, holidays etc. so wouldn't really have worked in a database as well. Ill have a mess with pivot tables though and see what i can come up with - Thanks :)

[GilbertZ]

It's been awhile since I worked with it, but if you build the pivot table around the last name of the employees it might give you what you want. Just make sure that the employee's last name is in the same cell for each sheet.