Hello Excel Forum,
I am a new user and looking for some much needed assistance.
Background:
I have two lists. The first ComboBox contains three departments: Department 1, Department 2, and Department 3.
The second ComboBox should contain ALL pumps located in "Selected Department" (each Department has a different list of pumps).
The list of pumps are located on a separate Sheet. Thus, I need to call the entire pump list into the second ComboBox, which is dependent on either Department 1, 2, or 3.
Goal:
In very simplistic form, it should look like this.
If the Value of ComboBox1 = Department 1,
Then the Value of ComboBox 2 = PumpListA.
If the Value of ComboBox1 = Department 2,
Then the Value of ComboBox 2 = PumpListB.
If the Value of ComboBox1 = Department 3,
Then the Value of ComboBox 2 = PumpListC.
I hope this is sufficient background information.
Thank You!
Bookmarks