multiple pull down boxes

[M G Henry]

I have a workbook with multiple worksheets.

The first worksheet is a form that relies on the other worksheets

The third worksheet has a long list of job numbers with descriptions
and the persons name who opened the job.

What I would like to do on the first worksheet ( form ) Is have a pull
down box that contains the names of the people opening the jobs. I
would like the selection from this list select only those jobs that he
or she opened.

Then in a second pull down box (limited to only the job numbers that
the person selected by the first pull down ) be able to see a list of
the job numbers ( in a second pull down box ) and then using vlookup
have it populate the job description field.

Thank you in advance for your help with this.

 

[CurlyDave]

Check this out for dependent drop down lists
http://www.contextures.com/xlDataVal13.html

Vlookup

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