ExcelBanter - View Single Post

Others

Thanks to you both!

"Gord Dibben" wrote:

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

On Thu, 22 Oct 2009 12:37:01 -0700, Others
wrote:

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

.