The only way I can think of to do this is with some formulas based upon
if_then statements that would be hidden on the worksheet and make up the drop
down list.

I'd like to have your spreadsheet to see if my idea will work before I try
to overcomplicate things by explaning an idea that might not work.

Would you feel comfortable sending me the sheet?



Thanks for the challenge

"Annabelle" wrote:

I have Software Review Report that I'd like to add dropdown lists from
a second worksheet, but unclear on how to execute. Can you assist?

1. I would like Review Type, Defect Type and Defect Cause to be drop
downs populated by the second worksheet.

The second worksheet has 5 different review types; each Review Type has
about 10 Defect Types; each Defect type has about 20 Defect Causes.
This is an example of what the second worksheet looks like:

Review Type Defect Type Defect Cause
RT1....................DT1....................DC1
...............................................DC2
...............................................DC3
..........................DT2..................DC1
...............................................DC2
..........................DT3..................DC1
...............................................DC2
...............................................DC3
...............................................DC4
RT2....................DT1..................DC1
...............................................DC2
...............................................DC3
..........................DT2..................DC1
...............................................DC2
..........................DT3..................DC1
...............................................DC2


2. The Review Type will determine which Defect Type and Defect Causes
are populated in their respective drop down.