Data Validation Criteria
Is there a way to use reference to other worksheets/workbooks for Dat
Validation Criteria -- Message posted from http://www.ExcelForum.com |
Data Validation Criteria
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/ |
Data Validation Criteria
|
Data Validation Criteria
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/ |
Data Validation Criteria
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/ |
All times are GMT +1. The time now is 08:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com