i am trying to use data validation for a single column.
I already have the list of possible values on another sheet "Analysis"
I can't seem to select this other sheet when choosing my validation list.
Is there a way round this?
XL2000
I already have the list of possible values on another sheet "Analysis"
I can't seem to select this other sheet when choosing my validation list.
Is there a way round this?
XL2000