Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting a range of worksheet tabs A-Z
Greetings to all,
My aim is to sort into A-Z order a range of worksheet tabs, I have a tab named 'A' and a tab named 'Z' and various tabs in between, that I would like to automatically sort A-Z, I also have some tabs prior to tab 'A' and after tab 'Z' that should remain unsorted and as they are. is it possible? Repects to all. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting a range of worksheet tabs A-Z
The free Excel add-in XL Extras will do that - plus some other nice stuff. Select one sheet... all sheets are sorted Select multiple sheets... the selected sheets are sorted. Download from... http://www.realezsites.com/bus/primitivesoftware No registration required -- Jim Cone San Francisco, USA "LaDdIe" wrote in message Greetings to all, My aim is to sort into A-Z order a range of worksheet tabs, I have a tab named 'A' and a tab named 'Z' and various tabs in between, that I would like to automatically sort A-Z, I also have some tabs prior to tab 'A' and after tab 'Z' that should remain unsorted and as they are. is it possible? Repects to all. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting a range of worksheet tabs A-Z
Thanks for your sugguestion Jim, i'll try that.
Good Health "Jim Cone" wrote: The free Excel add-in XL Extras will do that - plus some other nice stuff. Select one sheet... all sheets are sorted Select multiple sheets... the selected sheets are sorted. Download from... http://www.realezsites.com/bus/primitivesoftware No registration required -- Jim Cone San Francisco, USA "LaDdIe" wrote in message Greetings to all, My aim is to sort into A-Z order a range of worksheet tabs, I have a tab named 'A' and a tab named 'Z' and various tabs in between, that I would like to automatically sort A-Z, I also have some tabs prior to tab 'A' and after tab 'Z' that should remain unsorted and as they are. is it possible? Repects to all. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to name worksheet tabs using a cell within the worksheet? | Excel Discussion (Misc queries) | |||
Sorting Worksheet Tabs | Excel Worksheet Functions | |||
Can Excel worksheet tabs be relocated above the worksheet? | Excel Discussion (Misc queries) | |||
Sorting Tabs | Excel Discussion (Misc queries) | |||
sorting tabs | Excel Discussion (Misc queries) |