Thread: Dropdown Lists
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Annabelle
 
Posts: n/a
Default Dropdown Lists

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.