| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I sort worksheets based on the tab name?
I'm on Microsoft Office 2003. Is it possible to sort worksheets
alphabetically or numberically or any other way? For example, I want to have a different sheet for each person I am setting up. Their last name & 1st initial make up the name on the tab. I have 100+ names, & they are randomly set up, not in any order. After I finish, can I sort the worksheets alphabetically so that the tabs will be lined up by the person's last name? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I sort worksheets based on the tab name?
It looks like you have to do it using a macro. See the following KB
article for more information. http://support.microsoft.com/default...en-us%3B812386 Is that what you're looking for? -Ryan kaywe44 wrote: I'm on Microsoft Office 2003. Is it possible to sort worksheets alphabetically or numberically or any other way? For example, I want to have a different sheet for each person I am setting up. Their last name & 1st initial make up the name on the tab. I have 100+ names, & they are randomly set up, not in any order. After I finish, can I sort the worksheets alphabetically so that the tabs will be lined up by the person's last name? Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I sort worksheets based on the tab name?
Yes - thank you Ryan!
"Ryan Christiansen" wrote: It looks like you have to do it using a macro. See the following KB article for more information. http://support.microsoft.com/default...en-us%3B812386 Is that what you're looking for? -Ryan kaywe44 wrote: I'm on Microsoft Office 2003. Is it possible to sort worksheets alphabetically or numberically or any other way? For example, I want to have a different sheet for each person I am setting up. Their last name & 1st initial make up the name on the tab. I have 100+ names, & they are randomly set up, not in any order. After I finish, can I sort the worksheets alphabetically so that the tabs will be lined up by the person's last name? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to sort worksheets within a workbook | Excel Discussion (Misc queries) | |||
| sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
| sellect and sort worksheets by name in excel | Excel Discussion (Misc queries) | |||
| How do I sort data from various worksheets in the same workbook i. | Excel Worksheet Functions | |||
| Sort Worksheets | Excel Worksheet Functions | |||
Linear Mode
