There is probably an easier way to do this, but this is what I've got:
I created an evaluation spreadsheet with 4 sheets (Excel 2013).
Sheet 1: The Evaluation
Sheet 2: The list of Names and answers for data validation on sheet 1
Sheet 3: Raw data that would always get updated with a copy/paste that has Names and numbers
Sheet 4: A Pivot Table for each name in Sheet 3 for easy view of numbers per name
The Evaluation sheet B3 has data validation so a drop down can select the desired name.
What I am wanting to do is somehow have the C3 cell have a drop down so it will show all numbers for the name that was selected in cell B3 (based on the numbers in Sheet 3).
The purpose of attempting it this way, is that each day the pivots would be refreshed to populate the new numbers for names. They would be sorted newest to oldest, so the newest ones would always show first.
Any help would be greatly appreciated.
Bookmarks