View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim K[_3_] Tim K[_3_] is offline
external usenet poster
 
Posts: 1
Default Eliminating choices on data validation

I am not sure how to do this, but I hope it can be easily accomplished.

I would like to have Cell A1 to have a drop down box to choose data 1,2,3,4

Now, I would like the same for Cell A2 except eliminate the choice that was
chosen in cell A1.

So, if I choose 3 for cell A1 then my choices would only be 1,2,4 for cell
A2. Is this possible and how do I do it?

TIA, Tim