Data Validation Work Around

  • Thread starter Thread starter Neil M
  • Start date Start date
N

Neil M

Is there a work around to creating lists on wroksheets from other worksheets.
I would like to have one worksheet with all my reference lists and data on
it.
 
Is there a work around to creating lists on wroksheets from other worksheets.
I would like to have one worksheet with all my reference lists and data on
it.
Click to expand...

Yes create a named range. Go to insert name define... Give a range
or individual cell a name. then you can call the name from the data
validation by =Name. Then when your list gets bigger so does your
validation.
Jay
 
Watch this 5 min video:

How to setup a data validation drop down list:

 
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

Hide values in a Drop Down list 1
Search for duplicates in workbook 3
Data validation 3
Create a drop down list in Excel with 2 different work sheets 3
Data Validation - V-Lookup - 1
[err] Excel 2007 - Data validation from another sheet? 1
how do I copy continuous cells to everyother cell 2
Data Validation not working in shared file 4

Back
Top