Forum Discussion
Transferring data to another tab based on date
Hello Everyone, I'm a teacher. I have multiple classes. Some have 2 times 40 minutes a week, and others 1 times 80 minutes a week. Per 80 minutes I do 1 lesson (A lesson is 1 Tab in Excel). In e...
Yeah, I would prefer Google Sheets too, especially since it's online. However, considering my location that is not possible unfortunately.
Based on your response I searched for some ideas. Would something like this work?
https://www.extendoffice.com/documents/excel/2450-excel-vlookup-in-multiple-sheets.html
It would require more work putting formulas in many cells, and not be as elegant perhaps, but could it get the job done?
Thank you Anul for your efforts.
I've basically done an ugly work-around by making each cell refer to the corresponding Sheet cell, but it works. :)