| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you add cell values to drop down list for other cells | Excel Discussion (Misc queries) | |||
| Calculating values based on selection from a drop-down list in Exc | Excel Worksheet Functions | |||
| List box change values based on selection | Excel Discussion (Misc queries) | |||
| How to change drop down values based on another cell value? | Excel Discussion (Misc queries) | |||
| change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
Threaded Mode
