Darth_Williams
New Member
- Joined
- Oct 15, 2015
- Messages
- 25
Good morning,
Is there a way to create a summary sheet where I could enter a teachers name say in cell B2 and a table below will automatically populate with each students name and the grades they have in each topic?
I can make this work for one student but ideally I need to make it bring back every student that teacher is in charge of and I'm not ashamed to admit to being stumped
I have the main data sorted and I know that this is easily achieved with filters, but the powers that be want to see this on a summary page instead of using filters.
Any help will be appreciated.
Thank you
Is there a way to create a summary sheet where I could enter a teachers name say in cell B2 and a table below will automatically populate with each students name and the grades they have in each topic?
I can make this work for one student but ideally I need to make it bring back every student that teacher is in charge of and I'm not ashamed to admit to being stumped
I have the main data sorted and I know that this is easily achieved with filters, but the powers that be want to see this on a summary page instead of using filters.
Any help will be appreciated.
Thank you