cell validation

  • Thread starter Thread starter Dwill
  • Start date Start date
D

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.
 
Back
Top