Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DATE ORDER FOR QTR 1 -4 | Excel Discussion (Misc queries) | |||
Trying to calculate end date using order date and lead time variab | Excel Worksheet Functions | |||
How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
Sorting by date order | Excel Worksheet Functions | |||
Workbook date order | New Users to Excel |