Change drop down list in one cell based on values in other cells

H

Hemi

Hi, Can someone pls help. I want to update value in a drop down list based on
selection in preceeding drop down list e.g. there is a list of 10 business
units & within each business units there 15 to 20 sub business units. So if
business unit 'BU1' is selected in drop drop list in say cell A1 then on cell
A2 the drop down list should be populated with the corresponding sub-business
units of 'BU1'. Similarily if 'BU2' is selected in drop down list on cell A1
then on cell A2 the drop down list of corresponding sub-business units of
'BU2'. Hope it makes sense.
Cheers,
Hemi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Link a text box based on drop down box with four options MS Word 365 0
Using Drop Down list to an If Statement to another Drop Down list 3
Filtered drop down list 2
Help with drop down selection and populating related data... 9
Creating a Dropdown that is Related to the Value Given in Another Cell 6
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Print Macro w/drop down list 1

Top