Is there a way to use reference to other worksheets/workbooks for Dat
Validation Criteria

--
Message posted from http://www.ExcelForum.com

You can create a range (i.e. RangeName) that has the validation cells you want,
then choose "List" as the validation criteria. In the range selection, type
=RangeName. You can use the syntax in the same way as referencing other ranges
in workbooks/worksheets. hth

"taych " wrote in message
...
Is there a way to use reference to other worksheets/workbooks for Data
Validation Criteria ?


---
Message posted from http://www.ExcelForum.com/

Sorry Andy, try it out but does not work

--
Message posted from http://www.ExcelForum.com

Try putting in just =NamedRange for the Source under Allow: List. Below is the
range I have for NamedRange and all the cells that require this validation on any
worksheet find it. If I'm not understanding your question properly, my apologies
and I hope someone more experienced can offer another suggestion.

NamedRange:
=Sheet1!$G$28:$G$37

G28 List Item #1
G29 List Item #2
G30 List Item #3
G31 List Item #4
G32 List Item #5
G33 List Item #6
G34 List Item #7
G35 List Item #8
G36 List Item #9
G37 List Item #10

"taych " wrote in message
...
Sorry Andy, try it out but does not work.


---
Message posted from http://www.ExcelForum.com/

You can only reference within the sheet but you can have the validation list
hidden using white on white. If you do then I advise naming the list range.

Steve Whitnear

"taych " wrote in message
...
Is there a way to use reference to other worksheets/workbooks for Data
Validation Criteria ?


---
Message posted from http://www.ExcelForum.com/