Alphabetizing Worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 16 Mar 2006 19:07 GMT

Is there any way to automatically alphabetize worksheets? I can do it
manually by click and dragging, but not automatically. thanks.

Reply to this Message

Jim Cone - 16 Mar 2006 19:50 GMT

My free Excel add-in "Excel Extras" does that plus other nice stuff.
Download the newly updated version from here...
http://www.realezsites.com/bus/primitivesoftware
Jim Cone
San Francisco, USA

"Dave" <Dave@discussions.microsoft.com>
wrote in message...
Is there any way to automatically alphabetize worksheets? I can do it
manually by click and dragging, but not automatically. thanks.

Reply to this Message

Sloth - 16 Mar 2006 19:56 GMT

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

You will need VBA to do this automatically. The above link is Chip
Pearson's website which has your answer.

> Is there any way to automatically alphabetize worksheets? I can do it
> manually by click and dragging, but not automatically. thanks.

Reply to this Message

dcolbert - 16 Mar 2006 19:55 GMT

Thanks Sloth - good info.

Signature

Dave

> http://www.cpearson.com/excel/sortws.htm
>
[quoted text clipped - 3 lines]
> > Is there any way to automatically alphabetize worksheets? I can do it
> > manually by click and dragging, but not automatically. thanks.

Reply to this Message