I want to have a dependent drop down list of Divisions and Business units.
The menu items are in Sheet 1 and working sheet is 2
Divisions are HDC, Comm Ops, Corp Serv and Emp&Trng. Below each are listed Business Units
|HDC||Comm Ops||Corp Serv||Emp&Trng|
|Community Hubs||Supply Chain||Safety||Training|
In sheet 2 Column E the drop down is Division –
Column F should only give a drop down for the selected division.