We are creating form in excel and have 2 drop down menus - can you link
options from the first drop down box to the second - Example

Box #1 - has listing of deparment numbers

Box #2 - has listing of account numbers

We would like the outcome to be: Once the department is selected and you
are selecting a account number - we would like "Only" the account numbers
that pertain to that department as the option