Naming sheets with a list from another workbook;alphebetizing sheets

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
 
K

Ken Wright

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.
 
P

patrick

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning off automatic calculation 0
Mail Merge Directory Conditional Page Break 0
CountIf from multiple sheets in another workbook 4
Save workbook without shapes 0
selecting workbook/sheet 3
Sorting of No.Of Worksheets in a Workbook 1
Start sheet in a workbook 2
problems getting this macro to work 8

Top