PDA

View Full Version : Sleeper: Data Validation List(s)



inked
07-27-2006, 08:21 PM
I currently have two data validation list referenced against the days of the month.

When the main list is changed, data within the worksheet is changed to reflect that day.

I need the second list to automatically default to 7 days prior when the 1st list is changed. I still need for the user to be able to change the second list; however, when ever the 1st list is changes, the second list will again automatically default to 7 days prior.

Thanks for any help.

-ep

Bob Phillips
07-27-2006, 11:31 PM
I currently have two data validation list referenced against the days of the month.

When the main list is changed, data within the worksheet is changed to reflect that day.

I need the second list to automatically default to 7 days prior when the 1st list is changed. I still need for the user to be able to change the second list; however, when ever the 1st list is changes, the second list will again automatically default to 7 days prior.

Thanks for any help.

-ep

Just 7 days prior, or 7 before and upto that date, or maybe something else?