Snake Eyes
Board Regular
- Joined
- Dec 14, 2010
- Messages
- 103
- Office Version
- 365
- 2016
- Platform
- Windows
Greetings,
I have a table in which Column C, cells C10 thru C30 are referencing a data validation list (dates) on another worksheet in the same workbook.
I'm looking for a way to dynamically change the data validation reference to a different list on the same worksheet that contains the current list.
I can script out a macro (hopefully) however, something tells me there may be a better way.
How can I do this?
This is one list reference:
='Exp Dates'!$R$3:$R$55
This is the other option I would like to provide:
='Exp Dates'!$AH$4:$AH$15
I have a table in which Column C, cells C10 thru C30 are referencing a data validation list (dates) on another worksheet in the same workbook.
I'm looking for a way to dynamically change the data validation reference to a different list on the same worksheet that contains the current list.
I can script out a macro (hopefully) however, something tells me there may be a better way.
How can I do this?
This is one list reference:
='Exp Dates'!$R$3:$R$55
This is the other option I would like to provide:
='Exp Dates'!$AH$4:$AH$15