Sleeper: Data Validation List(s)

[inked]

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]

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?