cell validation

[Dwill]

I have cracked the list in a cell using the cell validation.

I have a list of around 30 which is a bit long and could be type in as
quick as scroll to find it.

Can I do something like this and if so, any pointers please

If in A1 I put room 1, can I have a validation from a certain named
range (which will mean about 5-8 choices) to selected in B1

then in A4 I put room 2 then a different named range (which will mean
about 4-7 choices) will be available in B4.

and so on...

Hope I explained that okish

Thanks in advance.

 

[Gord Dibben]

For the Autocomplete question see Debra Dalgleish's site for tips on using a
combo-box in conjunction with the DV dropdown.

http://www.contextures.on.ca/xlDataVal10.html

For the dependent list question see also Debra's site at

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP