|
DATE ORDER
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? Thanks |
DATE ORDER
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? |
DATE ORDER
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? |
DATE ORDER
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 |
DATE ORDER
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 |
DATE ORDER
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 |
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 |
DATE ORDER
In a General module:
Option Explicit Sub Auto_Open() msgbox "Hi from Auto_Open" End Sub In the ThisWorkbook module: Option Explicit Sub Workbook_Open() msgbox "hi from workbook_open" End Sub In any worksheet module: Option Explicit Private Sub Worksheet_Activate() MsgBox "Hi from worksheet_activate" End Sub If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Dave wrote: 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 -- Dave Peterson |
| All times are GMT +1. The time now is 07:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com