software

I have a different sheet for each person in an Excel workbook, and I have
named them in the format: quot;Last Name, Firstquot;. Is there a way to arrange them
all in alphabetical order at one time, or do I need to move each tab
individually?

You could use a macro:Zara wrote:
gt;
gt; I have a different sheet for each person in an Excel workbook, and I have
gt; named them in the format: quot;Last Name, Firstquot;. Is there a way to arrange them
gt; all in alphabetical order at one time, or do I need to move each tab
gt; individually?

--

Dave Peterson

You could use a macro:

Chip Pearson's:
www.cpearson.com/excel/sortws.htm

David McRitchie's:
www.mvps.org/dmcritchie/excel...#sortallsheets

If you're new to macros, you may want to read David McRitchie's intro at:
www.mvps.org/dmcritchie/excel/getstarted.htm

Zara wrote:
gt;
gt; I have a different sheet for each person in an Excel workbook, and I have
gt; named them in the format: quot;Last Name, Firstquot;. Is there a way to arrange them
gt; all in alphabetical order at one time, or do I need to move each tab
gt; individually?

--

Dave Peterson

There is no built-in function to do that.
However, the free Excel add-in quot;Excel Extrasquot; will do it.
Plus it can create a worksheet Table of Contents and do other nice stuff.
Comes with install/use Word.doc file.
Download from...
www.realezsites.com/bus/primitivesoftware

Jim Cone
San Francisco, USA

quot;Zaraquot;
gt;
wrote in message
I have a different sheet for each person in an Excel workbook, and I have
named them in the format: quot;Last Name, Firstquot;. Is there a way to arrange them
all in alphabetical order at one time, or do I need to move each tab
individually?