Hi

I am more of an excel user but i have a form to update at work and it requires the creationof drop down lists.

I finally figured out how to create the first one but now what I need to do is this:

when I select an option from the 1st drop down I need it to give me optiopns for the 2nd drop down.

For example the 1st drop down would have business units so wheni select a business unit i want it to show me the breakdown of individual departments ie legal, benefits, consultancy etc, but if I pick another it might have different departments.

I dont want to use macros if I can help it becasue I am not confident with them.

Any help please