Drop downs and look up

[Others]

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

 

[Ed Ferrero]

Hi Others,

This tutorial will walk you through a method for linking data from different
sheets
http://www.edferrero.com/ExcelTutorials/ExcelDatabaseTutorialPart1/tabid/90/Default.aspx

Ed Ferrero
www.edferrero.com

 

[Gord Dibben]

For the dependent dropdowns see Debra Dalgleish's site.

http://www.contextures.on.ca/xlDataVal02.html

For returning the values through VLOOKUP see also Debra's site.

http://www.contextures.on.ca/xlFunctions02.html

To refer to a named range in another sheet or workbook see

http://www.contextures.on.ca/xlDataVal05.html


Gord Dibben MS Excel MVP

 

[Others]

Thanks to you both!

For the dependent dropdowns see Debra Dalgleish's site.

http://www.contextures.on.ca/xlDataVal02.html

For returning the values through VLOOKUP see also Debra's site.

http://www.contextures.on.ca/xlFunctions02.html

To refer to a named range in another sheet or workbook see

http://www.contextures.on.ca/xlDataVal05.html


Gord Dibben MS Excel MVP



.

 

[Others]

I've checked out the link you provided...this is a great site. The problem
I'm having now is that some of these employees were trained in several
different tasks with different training dates for each. For ex: let's say
that Jane Doe was trained as a Bricklayer on 2/27/09 and then she was trained
as a Carpenter on 9/28/09. I see how to do this when using a simple list
where everyone's name is used once and if they've only been trained in one
task, but what about these people that have been trained in several different
areas?


Thanks,
Others