Date automatic but not changing afterward?

I'm creating a list of job with dates entered in excel.





I want today's date to be automaticly entered in a cell when someone's enter his name on the same line. That I can do with IF and NOW(). But What I want is for that date not to change after that. Right now if I go to the next line and enter a name, the date changes for today's date for all the lines.





Please be specifics I'm not very good in Excel.

Date automatic but not changing afterward?
Here's a demo http://www.freewebs.com/swhtam/YA/aDate4...


Alt+F11 to open vba editor, double click on icon Sheet1 on the left, that what it takes to get it running


On sheet1, the highlighted cells are for entering names, once name is entered, a date with time will be appeared in the cell next to it.


The range allowed for names is B2:B100 which correspond with the 2nd line of code, and you can change that to your range


To use the code on your sheet, open the workbook, go to vba editor, on left side (project window) click your worksheet icon under your workbook name, copy and paste the full code on the right blank area.


Please email for more details


Hope this helps.

dental supply