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