Naming sheets with a list from another workbook;alphebetizing sheets

  • Thread starter Thread starter Patrick Knott
  • Start date Start date
P

Patrick Knott

How do I alphabetize the sheets in a workbook.

Also, can I use a list from one workbook quickly create
another workbook with the list as the sheet names.

TIA
 
Please don't multipost. Changing the subject title but not the content and then posting to
different groups tends to get a few people hot under the collar, as it will fragment replies.

Take a look at the response in worksheet.functions that I gave you.
 
2K. Any chance we could work this by email?
-----Original Message-----
LOL - No probs, but what version of Excel do you have?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

--------------------------------------------------------- -------------------
Attitude - A little thing that makes a BIG difference
--------------------------------------------------------- -------------------






.
Click to expand...
 
Back
Top