View Single Post
  #1 (permalink)  
Old July 6th, 2016, 08:57 AM
albertoc albertoc is offline
Registered User
Points: 24, Level: 1
Points: 24, Level: 1 Points: 24, Level: 1 Points: 24, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2015
Posts: 6
Thanks: 1
Thanked 0 Times in 0 Posts
Default DropDown List content depending on condition

Good morning,

I have been struggling with a way to how generate specific text on a cell with dropdown list with the condition on two other cells.

Basically, if Cell C3=Object1 & Cell C5=Quantity1, I would like the dropdown list on Cell C7 to include Table1, Table2, Table3

Although, if if Cell C3=Object2 & Cell C5=Quantity1, I would like the dropdown list on Cell C7 to include Table4, Table5, Table6 and so on.

Does anyone know a tactic or a macro that can help me to do this?

Thank you very much for the help.

Regards.

Alberto Cortes.
Reply With Quote