Creating a timestamped Excel task log

mooglekit

Senior member
Jul 1, 2003
616
0
0
Hey Guys,
Any way to create a spreadsheet in Excel which timestamps each new entry and then sorts those from most recent to oldest? I'm trying to create somewhat of a task log which takes a text entry saying what was done, or changed and want to be able to keep track of when those tasks were finished or changed. Thanks for any help.
moogs
 

Drakkon

Diamond Member
Aug 14, 2001
8,401
1
0
Excel is a spreadsheet program and thus is not going to autosort after each entry nor does it have a date/time function that can be linked to a cell of data...You can however use the NOW() and TODAY() functions to display the current date/time...but when used in conjunction with excel formulas all of them get updated at one time usually...

If you want to create something like that you'd be better off using an Access application...give ya the abilities of excel with the power of access to do all the timestamping and sorting you want :D