Creating list in Combo box

[Srikanth H N]

Hello,
I have a Range from cell A1 to A3 named RAW which contains departments (Finance, Marketing, Production) and this is getting populated in combo box as list.
I have another combo box (2nd combo box), in which the list should appear based on the input in combo box1. eg. If i select Finance in combo box 1, then in combo box 2 list should show only AA, AB and AC, if I select Marketing in combo box 1, then in combo box 2 list should show only BA, BB and BC.
AA, AB, AC, BA, BB, BC are in cell B1 to B6.

How to create the input range for combo box 2 based on combo box1?

Thanks!
Srikanth H N

[pike]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.