If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change drop down list in one cell based on values in other cells
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 |
#2
|
|||
|
|||
Change drop down list in one cell based on values in other cells
Check out the below link by Debra..on dependent dropdown lists
http://www.contextures.com/xlDataVal13.html If this post helps click Yes --------------- Jacob Skaria "Hemi" wrote: 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 |
#3
|
|||
|
|||
Change drop down list in one cell based on values in other cel
Thanks Jacob for your help.
"Jacob Skaria" wrote: Check out the below link by Debra..on dependent dropdown lists http://www.contextures.com/xlDataVal13.html If this post helps click Yes --------------- Jacob Skaria "Hemi" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|