Referencing a range on a different tab than where data validation

  • Thread starter Thread starter Constance
  • Start date Start date
C

Constance

I have seen this done but wasn't available when the steps involved were
discussed. All I can remember of what I did catch was I believe the Indirect
function might have been used. In the example I saw, there was a named range
on one tab and on another tab, there was a cell with a data validation list
that reference the named range in such a manner that when the drop down box
was clicked the list displayed the contents of the entire named range. Would
anyone happen to know how this was done? Thank you!
 
Just using a named range for the other tab should be sufficient for what you
say that you want.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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
Data validation list using filtered range 3
Data Validation with dynamic ranges 2
Data Validation - dependant Lists 1
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
Filesize: embedded data validation lists all stored independently? 2
Offset Named range in Datavalidation List 4
SUMIF, use List as a Range 2

Back
Top