Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
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.
1 Answer
- AQuestionMarkLv 71 decade agoFavorite Answer
Here's a demo http://www.freewebs.com/swhtam/YA/aDate4AName.xls
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.
