| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to sort Worksheets
I have a file with a potentially variable number of worksheets. However
all worksheets will be exactly the same except for the Summary sheet need to sort the sheets in an order based on the cell value in cel c105. So, I have a Summary sheet where I want the sheet names to b listed. Alongside, I then want the value recorded of cell c105. I woul then data sort the range based on the values. Then i rename the sheets Sheet2,Sheet3 etc by means of variables to sort them into the order an then reassign the original sheet names. Does anyone have any clever code to deal with this? Thank -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| Help:macro to auto sort data to different worksheets... | Excel Discussion (Misc queries) | |||
| How do I sort Worksheets by name? | New Users to Excel | |||
| Sort Numerically Worksheets via VB when creating a new worksheets | Excel Programming | |||
| HELP sort 2 worksheets | Excel Programming | |||
![Stuart Farr[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
