Hello I am not sure which excel function would be best to resolve this. A little background I work in a school setting where students are taking multiple classes and the data given to me is one excel worksheet containing every student, class, and their progress in said classes.

I have a workbook with a “rawdata” sheet that contains multiple rows where the unique ID is the student name (I know this is not practical since names can be redundant), and the following columns show their progress in various classes. I have a second sheet “mystudents” which contains only the students under my purview whos data I want to see. I would like to pull all the rows of data from “rawdata” to a new sheet based on matching the students listed in “mystudents” sheet. 

I have tried using the advanced filter and selecting the “Copy to another location” button then setting the List Range: rawdata, Criteria range: mystudents but this is not working. Am I using the correct function to accomplish this? Any ideas? 

Here is an example of what the “rawdata” sheet looks like:

Here is an example of “mystudents” sheet:

So Ideally it would pull every Subject, Grade, and Progress for each one of my students John Doe and Yesenia Gutierrez. 

This is what I have attempted:

Am I missing something?

​Hello I am not sure which excel function would be best to resolve this. A little background I work in a school setting where students are taking multiple classes and the data given to me is one excel worksheet containing every student, class, and their progress in said classes.I have a workbook with a “rawdata” sheet that contains multiple rows where the unique ID is the student name (I know this is not practical since names can be redundant), and the following columns show their progress in various classes. I have a second sheet “mystudents” which contains only the students under my purview whos data I want to see. I would like to pull all the rows of data from “rawdata” to a new sheet based on matching the students listed in “mystudents” sheet. I have tried using the advanced filter and selecting the “Copy to another location” button then setting the List Range: rawdata, Criteria range: mystudents but this is not working. Am I using the correct function to accomplish this? Any ideas? Here is an example of what the “rawdata” sheet looks like:Here is an example of “mystudents” sheet: So Ideally it would pull every Subject, Grade, and Progress for each one of my students John Doe and Yesenia Gutierrez.  This is what I have attempted: Am I missing something?   Read More

​