Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort on opening a file
Does anybody know any way that I can get excel to sort data automatically
upon opening a file. I have a file that I use to keep track of my work where I set 'next action dates' for each section. I would like to be able to get Excel to automatically sort these so that each time I open the file the earliest next action dates appear at the top, without having to sort them manually each time. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort on opening a file
Record a macro when you select the worksheet
select the range to sort and do your sort. Now rename that macro Auto_Open Excel will run this macro each time you open the file (if you allow macros to run). If you need help tweaking your code, post back with your recorded code and describe what you want done. Phil51 wrote: Does anybody know any way that I can get excel to sort data automatically upon opening a file. I have a file that I use to keep track of my work where I set 'next action dates' for each section. I would like to be able to get Excel to automatically sort these so that each time I open the file the earliest next action dates appear at the top, without having to sort them manually each time. Thanks -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort on opening a file
Thanks Dave, thats brilliant, worked a treat!!
"Dave Peterson" wrote: Record a macro when you select the worksheet select the range to sort and do your sort. Now rename that macro Auto_Open Excel will run this macro each time you open the file (if you allow macros to run). If you need help tweaking your code, post back with your recorded code and describe what you want done. Phil51 wrote: Does anybody know any way that I can get excel to sort data automatically upon opening a file. I have a file that I use to keep track of my work where I set 'next action dates' for each section. I would like to be able to get Excel to automatically sort these so that each time I open the file the earliest next action dates appear at the top, without having to sort them manually each time. Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening a file in Excel starts application but dose not open file | Excel Discussion (Misc queries) | |||
Opening file in Excel 2003 opens multipule instances of same file | Excel Discussion (Misc queries) | |||
File:1 and File:2 -- Double Files when Opening One File | Excel Discussion (Misc queries) | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel |