T
taych
Is there a way to use reference to other worksheets/workbooks for Dat
Validation Criteria
Validation Criteria
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Andy
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
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
T
taych
Sorry Andy, try it out but does not work
A
Andy
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
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
S
SW
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
hidden using white on white. If you do then I advise naming the list range.
Steve Whitnear