Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop downs and look up
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop downs and look up
Hi Others,
This tutorial will walk you through a method for linking data from different sheets http://www.edferrero.com/ExcelTutori...0/Default.aspx Ed Ferrero www.edferrero.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop downs and look up
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop downs and look up
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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop downs and look up
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 "Ed Ferrero" wrote: Hi Others, This tutorial will walk you through a method for linking data from different sheets http://www.edferrero.com/ExcelTutori...0/Default.aspx Ed Ferrero www.edferrero.com . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating drop downs in a cell contingent on another drop down | Excel Discussion (Misc queries) | |||
Drop downs | Excel Discussion (Misc queries) | |||
drop downs | Excel Discussion (Misc queries) | |||
drop downs | Excel Discussion (Misc queries) | |||
Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions |