2013-10-22
New Member
- Joined
- Oct 22, 2013
- Messages
- 16
Using Windows 7, Excel that comes with Office 2010.
Hi,
I have a spreadsheet with various columns included in it.
Column H (Last Update) contains a column with format of dd/mm/yyyy hh:mm
The spreadsheet is used as a work issues list. When I update an item on the spreadsheet, I have been manually updating Col H with the current Date/Time and then re-sorting by Column H to show the most recently updated line at the top of the spreadsheet.
I wondered if it would be possible to:
1. Automatically update the time/date ColH value in the currently selected row when the file is saved
2. Automatically sort by ColH after step 1, so the most recently updated record is at the top of the file.
I realise the downside is that if I update 2 rows it won't be able to cope with that, but if the above could work it would be a big improvement over the current process.
Any advice much appreciated.
Thanks
Hi,
I have a spreadsheet with various columns included in it.
Column H (Last Update) contains a column with format of dd/mm/yyyy hh:mm
The spreadsheet is used as a work issues list. When I update an item on the spreadsheet, I have been manually updating Col H with the current Date/Time and then re-sorting by Column H to show the most recently updated line at the top of the spreadsheet.
I wondered if it would be possible to:
1. Automatically update the time/date ColH value in the currently selected row when the file is saved
2. Automatically sort by ColH after step 1, so the most recently updated record is at the top of the file.
I realise the downside is that if I update 2 rows it won't be able to cope with that, but if the above could work it would be a big improvement over the current process.
Any advice much appreciated.
Thanks