| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I alpha short worksheets in a workbook:
In a workbook I have many worksheets named with employee names. I want to
rearrange all the worksheets so that they are in alpha order. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I alpha short worksheets in a workbook:
You could use a macro:
Chip Pearson's: http://www.cpearson.com/excel/sortws.htm David McRitchie's: http://www.mvps.org/dmcritchie/excel...#sortallsheets If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm efward1 wrote: In a workbook I have many worksheets named with employee names. I want to rearrange all the worksheets so that they are in alpha order. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I alpha short worksheets in a workbook:
It has been 6 years since I worked in Excel. I use to sort the worksheets in
a workbook without the use of a macro. I just can't remember how the action is performed. I know there is a simply way to do it without macros. "Dave Peterson" wrote: You could use a macro: Chip Pearson's: http://www.cpearson.com/excel/sortws.htm David McRitchie's: http://www.mvps.org/dmcritchie/excel...#sortallsheets If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm efward1 wrote: In a workbook I have many worksheets named with employee names. I want to rearrange all the worksheets so that they are in alpha order. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I alpha short worksheets in a workbook:
You can click and drag the worksheet tabs to whereever you like.
efward1 wrote: It has been 6 years since I worked in Excel. I use to sort the worksheets in a workbook without the use of a macro. I just can't remember how the action is performed. I know there is a simply way to do it without macros. "Dave Peterson" wrote: You could use a macro: Chip Pearson's: http://www.cpearson.com/excel/sortws.htm David McRitchie's: http://www.mvps.org/dmcritchie/excel...#sortallsheets If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm efward1 wrote: In a workbook I have many worksheets named with employee names. I want to rearrange all the worksheets so that they are in alpha order. -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can you help me with ah "IF" calculation?
Thank you for your help, I will do it that way for now. Also,
could you help me figure out an formula for the following: if B6 is equal to OR greater than I4, then....... I how how to do an "IF" formula,,,but I do not know how to do one with "equal to or greater than" (at the same time) Thanks Faye "Dave Peterson" wrote: You can click and drag the worksheet tabs to whereever you like. efward1 wrote: It has been 6 years since I worked in Excel. I use to sort the worksheets in a workbook without the use of a macro. I just can't remember how the action is performed. I know there is a simply way to do it without macros. "Dave Peterson" wrote: You could use a macro: Chip Pearson's: http://www.cpearson.com/excel/sortws.htm David McRitchie's: http://www.mvps.org/dmcritchie/excel...#sortallsheets If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm efward1 wrote: In a workbook I have many worksheets named with employee names. I want to rearrange all the worksheets so that they are in alpha order. -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can you help me with ah "IF" calculation?
=if(b6=i4,"greater than or equal","less than")
efward1 wrote: Thank you for your help, I will do it that way for now. Also, could you help me figure out an formula for the following: if B6 is equal to OR greater than I4, then....... I how how to do an "IF" formula,,,but I do not know how to do one with "equal to or greater than" (at the same time) Thanks Faye "Dave Peterson" wrote: You can click and drag the worksheet tabs to whereever you like. efward1 wrote: It has been 6 years since I worked in Excel. I use to sort the worksheets in a workbook without the use of a macro. I just can't remember how the action is performed. I know there is a simply way to do it without macros. "Dave Peterson" wrote: You could use a macro: Chip Pearson's: http://www.cpearson.com/excel/sortws.htm David McRitchie's: http://www.mvps.org/dmcritchie/excel...#sortallsheets If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm efward1 wrote: In a workbook I have many worksheets named with employee names. I want to rearrange all the worksheets so that they are in alpha order. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protecting all worksheets of a workbook | Excel Discussion (Misc queries) | |||
| Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
| reference to consecutive worksheets within a workbook | New Users to Excel | |||
| Appending external worksheets into existing workbook? | Links and Linking in Excel | |||
| How do I build a workbook from the worksheets another workbook? | Excel Discussion (Misc queries) | |||
Linear Mode
