I have a spread sheet, where people can enter project updates and then the date of the update. What is happening is that people are forgetting to date their notes. Is there a way to have the date cell autopoplute the current/date of entry?
I am assuming an if function would do it?
This event macro will place the date in column B if a value is entered in column A. The macro should be installed in the worksheet code area:
Because it is worksheet code, it is very easy to install and automatic to use:
If you have any concerns, first try it on a trial worksheet.
If you save the workbook, the macro will be saved with it. If you are using a version of Excel later then 2003, you must save the file as .xlsm rather than .xlsx
To remove the macro:
To learn more about macros in general, see:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
and
http://msdn.microsoft.com/en-us/library/ee814735(v=office.14).aspx
To learn more about Event Macros (worksheet code), see:
http://www.mvps.org/dmcritchie/excel/event.htm
Macros must be enabled for this to work!
Change the code to use different columns.
EDIT#1:
This version will not overwrite material already present in column B:
ZAT's answer worked for me... AFTER I changed the ";"s to ","s.
I used "NOW" instead of "TODAY" to give me the time of day.
Try this formula in the desired cell (e.g C13) to fill the current date when corresponding input cell (e.g D13) is not empty and not filled with 0 :
And then you can copy this formula to the subsequent cells to fill in the formulas for that column (e.g col C)
Enter Date & Time in column A & B with the data entry in column D