View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
flashy flashy is offline
external usenet poster
 
Posts: 4
Default Multiple drop down list

I need step by step assistance in setting up a dropdown list which allows
each of the items in the list to have a drop down. I have been referred to
data validation, however I aparently am to dumb to understand how it is
supposed to work, following the example does not five me what I need.

My list needs to be dependent on cell C7 and P8. If C7="SF"and P8="1", then
I need a list in cells D16:D26 which has: Base, EXT, INT, Xtra, Other and
then each of those should allow a drop down to allow a selection of 4 - 9
different operations. I also need this to display in D16 or which ever cell I
am in D16:D26

If someone can suggest how to get this far, I think I could add the other 3
possible scenarios

Thanks for any assistance