Altering Data Validation in Excel 10

  Desert Andy 12:38 PM 23 Oct 12


I am setting up a worksheet to get data from a user. I have set up a data validation cell in D5 to get some information. The next cell I wish to get data from is cell D8. However, is it possible to change where the data validation looks for D8 depending on the answer the user gives in D5. I want the user to select from either of two lists, however, this is dependant on their first answer.

Thanks for any answers in advance


  lotvic 12:53 PM 23 Oct 12

Not my area but is this any help advanced-data-validation-techniques-in-excel

  Desert Andy 13:28 PM 23 Oct 12

Thank you, question answered!


This thread is now locked and can not be replied to.

Best Cyber Monday deals 2015 live blog: Best UK Cyber Monday tech deals, sales, discounts & offers

1995-2015: How technology has changed the world in 20 years

#AdventSauceJoyMince - generate a gratuitous Christmas tweet for #GivingTuesday charity

New MacBook Air release date, specs and rumours: 11in MacBook Air to be discontinued