Validation List

  • Thread starter Thread starter edwardpestian
  • Start date Start date
E

edwardpestian

How can I use a validation list from another worksheet?

Thanks in advance.

EP
 
Also, the list in the other worksheet is comprised of merged cells which
return the list improperly.

Regards,

EP
 
The easiest way is to give the list a name on the other sheet
insert_name_define. then in your cell validation choose list and type
the name of this list

Regards

Dav
 
Name the list (Insert>Name>Define)
and use the name in the validation dialog

HTH
 
It will still work, but you will be left with blank values as long a
the merging is in the same column. If it is merged over 2 columns i
will not work. Merging cells is often a bad idea in excel, it can caus
lots of problems.

Regards

Da
 
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

Checkboxes within a list 5
How to limit validation list 3
Range with 2 validations 5
2 validation lists for the same value on another cell 2
How Do I Find Different Values In A String? 2
Problem with data validation 2
Data Validation Not Erroring with List 2
Data validation error message not showing 2

Back
Top