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 ...
Power Query variant is in attached file
- Thank you so much Sergei, This looks like it will work for my purpose. Is it best to have the data and what is returned in different workbooks? Can you have it on a sheet in the same workbook?
It all depends on your business process. If you or someone else update results in the same file it could be done in separate sheets. If you copy/paste from another file it's more reasonable to use these other files as the source. It's also better from technology point of view.
- 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?
