I'm trying to figure out how to set my drop down lists to return a default value, from the source of the data validation list..which is a named range that is updated dynamically. The list shows the week numbers, so I would like the most recent week to always be the default value.
So if my dropdown list cell = A14 on Sheet1
and my most recent week cell = R3 on Sheet 2
How could you have the default be the value from R3?
Bookmarks