Dependent Drop downs

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
Accommodation Manufacturing  HR Employment 
Community Hubs  Supply Chain Safety  Training 
Other  Nursery  Finance  
  Cafe     

In sheet 2 Column E the drop down is Division – 

Column F should only give a drop down for the selected division.

 

 

By: Mohammed

Leave a Reply

Your email address will not be published. Required fields are marked *