Data validation list question

  • Thread starter Thread starter Cheryl
  • Start date Start date
C

Cheryl

D2:D101 has a data validation list (ten two letter codes)
applied to it.

I want to apply the same validation list to E2:E101 and
F2:F101 but want to limit the codes available.

For example:
I picked MV in D2, I don't want MV to be an option in E2
or F2.
I pick HJ in D2 then MV in E2, I don't want either of
these to be options in F2.

Also, is there any way to ensure that users start at
column D?

Thanks in advance.

Cheryl
 
Thanks for this, with a little amending I got it working
for the 3 columns.

One problem, after selecting something in row 2 its
missing from row 3 etc, etc.

I only want it to limit the lists acorss a row not down in
the column as well.

Any help gratefully received.
 
Back
Top