Refer to seperate workbook for validation list for drop downs?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Id like to keep my validation data for drop downs in a seperate workbook so
that many users/worksheets can reference it. However- data validation doesnt
seem to let me reference named ranges in a seperate workbook- any advise out
there?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Drop Down List Contains the List Header Row 1
create drop down list from different workbook 2
Data Validation for list in a different workbook 2
Drop Down List + Validation 1
problem with drop down lists 1
Drop down Lists from a different workbook 1
Referring to external workbook in Data Validation 2

Back
Top