Forum Discussion
Transferring data to another tab based on date
Yes, it's hard; I suggested google drive because it does that with no difficulties, but if you won't have any internet connection, you can't use it.
The problem with looking in other sheets is that you need to insert manually every sheet name because it automatically changes the cells (A3:A600) but not the part before (sheet2!). So you have to rename sheet2 with all the sheets you need to check, and "sheet2:sheet90" is not a valid parameter because you can't search between sheets like that. The ":" marker is valid only for cells in the same sheet.
Anyway, once we find out how to set the page in order to have an easy formula that solve your problems, the other parameters (lesson number, units...) are easy to add by a simple INDEX or VLOOKUP.
You (we) need to re-think the whole file...
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. :)