Forum Discussion
Returning specific cell contents across a range
Like Riny_van_Eekelen I am not absolutely sure of the significance of elements of master table such as the 1EX. I have taken it as a teacher ID but it might be open to other interpretation. Since the workbook functioned at all, I assume you have an up to date version of Microsoft 365 on your Mac.
The attached file has been changed to output the normalised data form I used within Power Query. I also modified the formulas to use lesson numbers which are now created by formula rather than being text labels.
The defined Names used on each worksheet are local names, specific to the sheet. That means that copying the sheet simply creates a new set of names and the formulas should work correctly.
That works so well - thank you! My only question now is how to add the other classes (not in the example timetable) can I just copy the sheets you've created and change the class name?
Like Riny_van_Eekelen I am not absolutely sure of the significance of elements of master table such as the 1EX. I have taken it as a teacher ID but it might be open to other interpretation. Since the workbook functioned at all, I assume you have an up to date version of Microsoft 365 on your Mac.
The attached file has been changed to output the normalised data form I used within Power Query. I also modified the formulas to use lesson numbers which are now created by formula rather than being text labels.
The defined Names used on each worksheet are local names, specific to the sheet. That means that copying the sheet simply creates a new set of names and the formulas should work correctly.