Date formula
- Thread starter dchatrie
- Start date
I would probably add a timestamp to every entry and then look for the last entry in your database upon opening the workbook. For every new entry into your database, you might try something like:
[pre]
[/pre]
Obviously, you can replace currentRow or timeStampColumn, but you do want to keep the part where you set the cell's value to Now. Now is an timestamp of the current time and date, which is available as an internal variable for use in the VBE. It is not a variable that needs to be declared.
[pre]
Code:
ActiveSheet.Cells(currentRow, timeStampColumn).Value = NowObviously, you can replace currentRow or timeStampColumn, but you do want to keep the part where you set the cell's value to Now. Now is an timestamp of the current time and date, which is available as an internal variable for use in the VBE. It is not a variable that needs to be declared.
Space (Ctrl + NARAYANK991
Excel Ninja
Hi dchatrie ,
I am not sure I have understood your requirement ; your first sentence says you would like the last entry to be time-stamped ; your next sentence says when you open the workbook you would like to know when it was last updated ; these are not necessarily the same.
If you need to know when a workbook was last updated , you can have the Workbook_BeforeClose event put the timestamp before exiting ; you can use the Workbook_SheetChange event to ensure that some cell in the workbook has been changed.
Narayan
I am not sure I have understood your requirement ; your first sentence says you would like the last entry to be time-stamped ; your next sentence says when you open the workbook you would like to know when it was last updated ; these are not necessarily the same.
If you need to know when a workbook was last updated , you can have the Workbook_BeforeClose event put the timestamp before exiting ; you can use the Workbook_SheetChange event to ensure that some cell in the workbook has been changed.
Narayan
I can't imagine non-automated way of knowing the date of the last input without some VBA. You could use NOW() as a formula in Excel (for example, "=NOW()"), but every time there's a calculation, the formula will update to the most current point in time. If you do not want to use VBA, then you will have to find a manual way of capturing the last date of input - which might just be typing in a date for each entry. But perhaps the ninja's know better than me.