I'm using Excel2003... Here's what I have:

Sheet 1
ColumnA Column B Column C
Maintenance Crane Carry Deck
Crane Shuttlelift
Electrician
Forklift


Sheet 2
ColumnA ColumnB ColumnC Column D
ColumnE
Y-Bricklayer 100 Jane Doe Millwright 2/27/2009
Y-Bricklayer 200 John Doe Process Att 2/27/2009
Y-Bricklayer 300 John Smith Process
Att 2/27/2009
Y-Bricklayer 400 Jane Smith Process
Att 2/27/2009
C-Carpenter 800 Jan Smith Millwright 4/29/2008
C-Carpenter 900 Joe Blow Millwright 9/26/2008
C-Carpenter 600 Jane Blow Process Att 5/1/2008





These sheets are in different workbooks. I need to put a drop down list in
Sheet 1 in Column C to be able to choose from Bricklayer, Carpenter,
etc...depending on which of these is chosen I'd like another option to choose
from the names in that category. After choosing a name from the category I'd
like all of their information to show up (clock #, name, Job class and task
training date). I can't figure out how to get all of the information to show
up. I'm terrible with codes! Help?


Thanks in advance for your time,
Others