Using a 'Select' (Data Validation) List?

  • Thread starter Thread starter dezdan
  • Start date Start date
D

dezdan

Howdy! I have a spreadsheet with a few hundred entries in it on sheet
1. One of the columns in the sheet is State, and an adjacent column is
County. I am only working with 3 or 4 states, but combined they have a
lot of counties! Since the Data Validation list option only holds so
many entries, I have had to add just the counties most used.

What I would like to do, is when a certain state is selected in column
'A' from a list, the list for column 'B' will show Only counties from
that state. Now I know the basics of how to do this - using an if
statement to check to see what column 'A' is, and to then pull the list
of counties from another sheet (sheet 3 for me), but I do not know how
to put it all together code wise. Any help would be very much
appreciated!

Thanks!
~Dan
 
Thanks for the reply Ron! It does help, but it appears that it will not
work across sheets (ie: all my data will have to be on the same sheet -
which I don't want). Any other suggestions?

Thanks,
~Dan
 
All of which data would have to be on one sheet?
Which part isn't working?
Does the dependent list display the wrong data? No data?
Are you using Dynamic Ranges?

Does that help?

***********
Regards,
Ron
 
Dan

You can use Lists from other sheets if you name the Lists.


Gord Dibben Excel MVP
 
Thanks for the follow-up Ron, and sorry about my delay.

My data for the both the main list and the dependent list are on the
same sheet, though the lists are being used on another sheet in the
same workbook. My trouble is is creating the dependent data validation
using the INDIRECT function. I am using: =INDIRECT(Data!A2) for which
I receive the following error: "You may not use references to other
worksheets or workbooks for Data Validation criteria." This is where I
am currently stuck. I really do not want to have the data for the list
on the same sheet that I am working on. Any help?

Thanks,
~Dan
 
My list are named, however my trouble is creating a dependent data
validation list using the INDIRECT function. I receive the error: "You
may not use references to other worksheets or workbooks for Data
Validation criteria."

~Dan
 

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

Vlookup into 2 columns 2
Can I create a dropdown list to select multiple items 2
Finding a value based on contents of two cells 3
multiple dropdown selections 3
Pivot and count question. 3
EXCEL FORMULA 6
Sum? IF? function 3
How to have Excel Fill In Data in Column based on another columns 3

Back
Top