Data Validation List

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

Guest

I'm trying to place a drop down list in a cell and it is
not working. I placed it on one worksheet, but it doesn't
work on the other. I put what I want to drop down (6
items, each in a separate cell), but the list doesn't
show. Any suggestions?
 
You cannot use a range of cells, say Sheet2!A1:A6 in Data Validation, but if
you name the range as MyList or whatever and use =MyList in the cell in
another sheet, it will work,
Regards,
 
If you want it to refer to a range on another sheet, you need to name that
range, and use the name in the DV list.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
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 (Drop Down) Not Showing 2
Data validation only works once 1
Filtered drop down list 2
Data validation list using filtered range 3
Data Validation List 1
How to edit the size of a drop-down list (using data validation)? 1
Data Validation drop-down 5

Back
Top