Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Location: Ohio
Posts: 1
Send a message via AIM to btrich14
Smile 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   Report Post  
Senior Member
 
Location: Philippines
Posts: 161
Default

Quote:
Originally Posted by btrich14 View Post
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?
If this is a TIME STAMP, you'll need a macro for it.

http://www.mcgimpsey.com/excel/timestamp.html
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto copy data rows between sheets depending on date entry Struggling in Sheffield[_2_] New Users to Excel 3 September 27th 09 01:36 PM
How to auto-populate worksheet based on cell entry? tgcali Excel Discussion (Misc queries) 4 April 13th 09 04:11 PM
Any way to check what date a specific data entry (cell) was entere databird Excel Discussion (Misc queries) 4 March 26th 08 02:55 AM
Search for a specific entry in a long data validation list Heinrich Excel Discussion (Misc queries) 1 May 4th 07 07:29 PM
Use Validation to force specific entry of first 3 characters in st ron Excel Worksheet Functions 4 February 15th 06 09:09 PM


All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"