Data Validation List

[kgkev]

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

 

[WaterGypsy]

Name the range and use the name in the validation box instead of the range in normal notation

 

[VoG]

Yes - you need to create a named range. See http://www.contextures.com/xlDataVal01.html

 

[kgkev]

Sorted - Thanks for your help