Validation

  • Thread starter Thread starter zoot
  • Start date Start date
Z

zoot

I am trying to validate a cell using the Validation drop down box.

I have a list of items and I want this to make up the list, however the list
is in a seperate worksheet within the same workbook. Can someone please
help me reference these cells for the drop down list.

Thank you
Dan
 
Try this:

Give the list a rangename e.g. MyList

In data validation - list dialogue box enter this range as a formula
=MyList
 
validation data has to be on the same worksheet.

you can have a zone on the current worksheet that = the other sheet (with
the data)
 
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

data validation list 17
Selective data validation list 1
Turning on data validation in one cell based on the contents ofanother cell 1
Data Validation 1
Drop down list from index/match formula 1
data validation across many worksheets 2
Drop-down list and error message 1
My Validation Lists Won't Work, Help! 15

Back
Top