Forum Discussion
Transferring data to another tab based on date
Hi Arul,
I only just now learned that pushing data to other cells is hard.
So perhaps instead, in Sheet1, there could be a formula that Looks up the last date entered in Sheet2 (Sheet3:Sheet90) and add the data on the following empty row. As there are more cells that require information to be copied (homework/attendance), lesson number, unit number, perhaps this would require a few formulas?
I don't pretend to have an answer, I'm merely trying to learn and figure out if my thinking regarding excel is improving :)
Any help is greatly appreciated ! :)
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. :)