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

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?

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?

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

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

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