Forum Discussion
Return multiple values across multiple sheets
I have multiple sheets in a workbook for teachers to record marks in tests students take. Students will progress through these tests at different rates and I want a summary of what test students are ...
Thanks Sergei,
What you have created works perfectly although I am at a bit of a loss as to how to translate what you have done to my whole spreadsheet. Is there somewhere with the steps so I can see how to apply it to my whole set of data and expand what you have done for a whole school of student names and multiple sheets of data?
What you have created works perfectly although I am at a bit of a loss as to how to translate what you have done to my whole spreadsheet. Is there somewhere with the steps so I can see how to apply it to my whole set of data and expand what you have done for a whole school of student names and multiple sheets of data?
In theory it shall work if you
1) Change the file path within dashboard Excel sheet on one where is you actual file with tests result
2) Sheet names with test results start from the works "Subtest" (case sensitive)
3) Each sheet has exactly the same structure and some number of columns as in sample file.
Otherwise, i.e. file is located on SharePoint site, sheet names have another logic or we select all sheets in such file; sheets have bit different structure - query shall be modified.
If you are not familiar with Power Query it's hard to say what exactly to do. In general in Power Query editor check step by step each query and correct what doesn't work.