Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Linking Lists and Filters between Worksheets in Excel
Hello, I have two worksheets in this workbook. One worksheet has the names of
students that I have, what classses they are in, and their contact information. The second worksheet has the names of the students that I have, the tests they took, and all the answers they gave for each test. A Hypothetical Example: Worksheet 1: Jerry Economics Classroom #104 Jimmy Finance Classroom #104 Natalie Economics Classroom #334 Amy Finance Classroom #104 Worksheet 2: Jerry Test #1 Question 1: A Question 2: A (...) Jimmy Test #1 Question 1: C Question 2: B (...) Natalie Test #2 Question 1: B Question 2: C (...) Amy Test #1 Question 1: A Question 2: C (...) So, what I want to do is pull down the list in Worksheet 1 that has what class they are taking and filter out only those students who are taking Economics and somehow link that action to Worksheet two. So, that when I move over to Worksheet 2 it will only display the test answers to the students in my Economics class. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Linking Lists and Filters between Worksheets in Excel
Can a stunded by in two classes? If not then you can just add the class to
the student name in test sheet and filter... Here is the VLOOKUP formula if this is an acceptable solution. Enter in first available col in sheet 2 =VLOOKUP(A1,Sheet1!A:B,2,False) and copy down Change Sheet1 to acutal name of your sheet... "kilgore.of.trout" wrote: Hello, I have two worksheets in this workbook. One worksheet has the names of students that I have, what classses they are in, and their contact information. The second worksheet has the names of the students that I have, the tests they took, and all the answers they gave for each test. A Hypothetical Example: Worksheet 1: Jerry Economics Classroom #104 Jimmy Finance Classroom #104 Natalie Economics Classroom #334 Amy Finance Classroom #104 Worksheet 2: Jerry Test #1 Question 1: A Question 2: A (...) Jimmy Test #1 Question 1: C Question 2: B (...) Natalie Test #2 Question 1: B Question 2: C (...) Amy Test #1 Question 1: A Question 2: C (...) So, what I want to do is pull down the list in Worksheet 1 that has what class they are taking and filter out only those students who are taking Economics and somehow link that action to Worksheet two. So, that when I move over to Worksheet 2 it will only display the test answers to the students in my Economics class. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Linking Lists and Filters between Worksheets in Excel
Hello Sheeloo:
Thank you for your response. I never knew about VLOOKUP or HLOOKUP, so thank you for educating me. However, this isn't really what I was looking for. I'm hoping that there is a way I can link the two lists without having to use a test sheet. I'd like to just filter Worksheet 1 and have the corresponding data on Worksheet 2 filter aswell. I'm suspecting that this function doesn't exist in Excel. kilgore.of.trout "Sheeloo" wrote: Can a stunded by in two classes? If not then you can just add the class to the student name in test sheet and filter... Here is the VLOOKUP formula if this is an acceptable solution. Enter in first available col in sheet 2 =VLOOKUP(A1,Sheet1!A:B,2,False) and copy down Change Sheet1 to acutal name of your sheet... "kilgore.of.trout" wrote: Hello, I have two worksheets in this workbook. One worksheet has the names of students that I have, what classses they are in, and their contact information. The second worksheet has the names of the students that I have, the tests they took, and all the answers they gave for each test. A Hypothetical Example: Worksheet 1: Jerry Economics Classroom #104 Jimmy Finance Classroom #104 Natalie Economics Classroom #334 Amy Finance Classroom #104 Worksheet 2: Jerry Test #1 Question 1: A Question 2: A (...) Jimmy Test #1 Question 1: C Question 2: B (...) Natalie Test #2 Question 1: B Question 2: C (...) Amy Test #1 Question 1: A Question 2: C (...) So, what I want to do is pull down the list in Worksheet 1 that has what class they are taking and filter out only those students who are taking Economics and somehow link that action to Worksheet two. So, that when I move over to Worksheet 2 it will only display the test answers to the students in my Economics class. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Linking Lists and Filters between Worksheets in Excel
No, it does not.
Excel provides basic building blocks which we can use to build our dream house :-) "kilgore.of.trout" wrote: Hello Sheeloo: Thank you for your response. I never knew about VLOOKUP or HLOOKUP, so thank you for educating me. However, this isn't really what I was looking for. I'm hoping that there is a way I can link the two lists without having to use a test sheet. I'd like to just filter Worksheet 1 and have the corresponding data on Worksheet 2 filter aswell. I'm suspecting that this function doesn't exist in Excel. kilgore.of.trout "Sheeloo" wrote: Can a stunded by in two classes? If not then you can just add the class to the student name in test sheet and filter... Here is the VLOOKUP formula if this is an acceptable solution. Enter in first available col in sheet 2 =VLOOKUP(A1,Sheet1!A:B,2,False) and copy down Change Sheet1 to acutal name of your sheet... "kilgore.of.trout" wrote: Hello, I have two worksheets in this workbook. One worksheet has the names of students that I have, what classses they are in, and their contact information. The second worksheet has the names of the students that I have, the tests they took, and all the answers they gave for each test. A Hypothetical Example: Worksheet 1: Jerry Economics Classroom #104 Jimmy Finance Classroom #104 Natalie Economics Classroom #334 Amy Finance Classroom #104 Worksheet 2: Jerry Test #1 Question 1: A Question 2: A (...) Jimmy Test #1 Question 1: C Question 2: B (...) Natalie Test #2 Question 1: B Question 2: C (...) Amy Test #1 Question 1: A Question 2: C (...) So, what I want to do is pull down the list in Worksheet 1 that has what class they are taking and filter out only those students who are taking Economics and somehow link that action to Worksheet two. So, that when I move over to Worksheet 2 it will only display the test answers to the students in my Economics class. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Excel Worksheets | Excel Worksheet Functions | |||
worksheets linking in Excel? | Excel Worksheet Functions | |||
Linking worksheets in Excel | Excel Discussion (Misc queries) | |||
Linking Excel Worksheets | New Users to Excel | |||
Linking Excel Worksheets | Excel Worksheet Functions |