Re: Return subset to drop down box

Check out this web page of Debra Dalgleish under the subject of dependant
lists:

http://www.contextures.com/xlDataVal02.html


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
<tbrogdon@xxxxxxxxx> wrote in message
news:1193593217.780289.25330@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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


.