Return subset to drop down box

Tech-Archive recommends: Fix windows errors by optimizing your registry

I work at a production plant. We have 3 shifts.

I have a workbook to track production.

On the opening *** of the workbook I would like each supervisor to
input which shift (1, 2, or 3) they are inputting data for via drop
down box. Then on the next *** - and this is where I need guidance -
how can I have the input from the 1st *** (Shift Number) return a
list (from another work*** further back in the same workbook) via
another dropdown box of the employees that are assigned to the
returned shift?

In other words, if the supervisor selects "2" from a drop down box
titled "Shift" on the first page how can I return a list of all the
employees who are on second shift to another drop down box on the
second work*** in the workbook?

Lets call the workbook: ProductionBook.
The first page where the supervisor selects the date and shift number:
OpeningPage.
The second page where I need the guidance we can call:
ProductionInput.
The page with the employees info: Employees


Thanks a bunch,

Tim

.

Quantcast