| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto sort when worksheet/book opened
Two parts to this I'm afraid ....
I have a sheet that ranges A to S and down. When another sheet updates I have a formula running to auto update columns A & B with Last Name & First name which works well - I want to have the sheet auto sort each time it is opened by column A - 1. How do I do this please 2. Can I make it only sort when there are names in the cells rather than including the formulas which at this point show as 0 until updated beacuse at this point when sorted the 0's all go to the top?? Assistance as always appreciated. -- Thanks Lise |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I set up Excel sheet that auto increments a no. when opened | Excel Discussion (Misc queries) | |||
| can I sort the order of sheets in a book? | Excel Discussion (Misc queries) | |||
| sort excel when the workbook is opened | Excel Discussion (Misc queries) | |||
| How to auto activate macro when file opened | Excel Worksheet Functions | |||
| auto insert invoice number that increases by one each time opened | Excel Worksheet Functions | |||
Threaded Mode
