Friends,
I'm hoping there's a simple (non VBA) solution to this question. I want to use a named range of value as the lookup list for Data Validation. The range is on the same sheet as the cell I want to validate.
It appears, however, that any lists reference the lookup values by absolute cell references.
Can I use the values in my named range as my validation list?
Jimbo
I'm hoping there's a simple (non VBA) solution to this question. I want to use a named range of value as the lookup list for Data Validation. The range is on the same sheet as the cell I want to validate.
It appears, however, that any lists reference the lookup values by absolute cell references.
Can I use the values in my named range as my validation list?
Jimbo