I have a workbook where each worksheet name is the name of an employees
(surname & initial), total of around 50 different names.
Is there a quick way to sort the sheets into alphabetical order or does it
need to be done manually?
TIA
--
Jan
I have a workbook where each worksheet name is the name of an employees
(surname & initial), total of around 50 different names.
Is there a quick way to sort the sheets into alphabetical order or does it
need to be done manually?
TIA
--
Jan
You can do it with code. Check out this web page
http://www.cpearson.com/excel/sortws.htm
--
HTH
RP
(remove nothere from the email address if mailing direct)
"mate" <[email protected]> wrote in message
news:[email protected]...
> I have a workbook where each worksheet name is the name of an employees
> (surname & initial), total of around 50 different names.
>
> Is there a quick way to sort the sheets into alphabetical order or does
it
> need to be done manually?
>
> TIA
>
> --
> Jan
>
>
Works great, thanks very much.
"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> You can do it with code. Check out this web page
> http://www.cpearson.com/excel/sortws.htm
>
> --
>
>> I have a workbook where each worksheet name is the name of an employees
>> (surname & initial), total of around 50 different names.
>>
>> Is there a quick way to sort the sheets into alphabetical order or does
> it
>> need to be done manually?
>>
>> TIA
>>
>> --
>> Jan
>>
>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks