| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Auto Populate Date when specific entry is chosen from data validation
Hello. I just joined this site and I am very entertained at all of the great posts. Excel is quite the powerful tool, I am just starting to scratch the surface of its potential and cannot wait to try out all the tips on here. What I am looking for some help on is this:
I have a spreadsheet to track the status of a project for a group of reps. I created a status for each line item using data validation. One of the selections is time sensitive and I need excel to populate the column next to it with the date that this particular selection is chosen and then keep that date there once the status has moved beyond that. Can anyone help? |
|
#2
|
|||
|
|||
Quote:
http://www.mcgimpsey.com/excel/timestamp.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto copy data rows between sheets depending on date entry | New Users to Excel | |||
| How to auto-populate worksheet based on cell entry? | Excel Discussion (Misc queries) | |||
| Any way to check what date a specific data entry (cell) was entere | Excel Discussion (Misc queries) | |||
| Search for a specific entry in a long data validation list | Excel Discussion (Misc queries) | |||
| Use Validation to force specific entry of first 3 characters in st | Excel Worksheet Functions | |||
Linear Mode
