Create Data Validation list on worksheet 1 from named ranges on worksheet 2

[dukebluedevil]

Anyone know how to do this?

 

[SteelReyn]

Have you tried naming the list on Worksheet 2, say "ListOfThings" and then referencing that list in your data validation cell on Worksheet 1? Once you have your named range, go to the cell you want to have a validation list, select Data Validation, Allow List, and the Source should be =ListOfThings. That should do it.

 

[dukebluedevil]

SteelRyan, so I have named ranges in worksheet 1 that correspond to cell ranges that I want to incorporate into an Index formula that I am writing in worksheet 2. When I select Data Validation > List > Source I do not see the list of named ranges that I would like to have populate that list. If I understand your post correctly, do you suggest that I recreate the list on worksheet 2 that corresponds to the named ranges in worksheet 1 and then reference that re-created list in worksheet 2?

Thank you for your time, consideration, and experience.

 

[dukebluedevil]

Specifically, I want to use Indirect () to grab the named range and incorporate the corresponding range of cells into a calculation on worksheet 2