sorting worksheets

[Hein]

Hallo

In several Excel files I would like to sort the worksheets by name.
In some files there are almost 100 worksheets and I would like to cut them up into smaller pieces/files.

Sorted workshets makes the task easier

Hope somebody knows what to do!?

Thanks
Hein

[Paul B]

Hein, have a look here at Chip's site for a way to do it,

http://www.cpearson.com/excel/sortws.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Hein" <[email protected]> wrote in message
news:[email protected]...
>
> Hallo
>
> In several Excel files I would like to sort the worksheets by name.
> In some files there are almost 100 worksheets and I would like to cut
> them up into smaller pieces/files.
>
> Sorted workshets makes the task easier
>
> Hope somebody knows what to do!?
>
> Thanks
> Hein
>
>
> --
> Hein
> ------------------------------------------------------------------------
> Hein's Profile:
> http://www.excelforum.com/member.php...o&userid=24744
> View this thread: http://www.excelforum.com/showthread...hreadid=495168
>

[Hein]

Thanks Paul
Seems like it's what I'm looking for! :-)

Hein

Edit
Works great!!
Thanks Paul

[CLR]

Jim Cone's free Add-in called XL Extras has a feature that will sort the
sheets for you. It's available at:

http://www.realezsites.com/bus/primi...are/index.php?

Vaya con Dios,
Chuck, CABGx3



"Hein" wrote:

>
> Hallo
>
> In several Excel files I would like to sort the worksheets by name.
> In some files there are almost 100 worksheets and I would like to cut
> them up into smaller pieces/files.
>
> Sorted workshets makes the task easier
>
> Hope somebody knows what to do!?
>
> Thanks
> Hein
>
>
> --
> Hein
> ------------------------------------------------------------------------
> Hein's Profile: http://www.excelforum.com/member.php...o&userid=24744
> View this thread: http://www.excelforum.com/showthread...hreadid=495168
>
>