Posted to microsoft.public.excel.misc
|
|
DATE ORDER
Hi Dave
How do you do this?
Thanks
"Dave Peterson" wrote:
Open a workbook or activate a worksheet?
If you mean open a workbook, you can use the Auto_Open procedure in a General
module or you can use the Workbook_Open event in the ThisWorkbook module.
If you mean activate a sheet, you can use that sheet's worksheet_activate event
in that worksheet's module.
Dave wrote:
Thanks Dave
Thats a good idea. Im sure there is a way of making the macro run everytime
you open the sheet? Do you know how this is done?
Thanks
"Dave Peterson" wrote:
Record a macro when you sort your data.
Run this macro whenever you want to.
Dave wrote:
Hi Max
Of course this would be the simple solution however not practical for my
needs. I need the spreadsheet to automatically keep the rows in date order.
Any solution to this problem would be greatly appreciated.
Thanks
"Max" wrote:
Why not just sort your table by the date col (ascending) at the end of the day?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Dave" wrote:
Hi, I have a spreadsheet in which I log events by date. Sometimes the last
event entered in the last row is not the most recent. Is the a way that excel
can move this row into date order?
--
Dave Peterson
--
Dave Peterson
|