Forum Discussion
Transferring data to another tab based on date
Do you already have an excel file to show us? I'm trying to understand exactly what you need and I don't want to waste your time (and mine!) working on a useless prediction of your needs.
Hello Arul,
Yeah, I made the excel sheet (see attachment)
The data (blue and red) from Sheet2 (and later Sheet3, 4, 5, etc.) should go to Sheet1, but only if a date was filled in Sheet2 (red). If only 1 date is filled in, only that line of blue data should be visible in Sheet1.
With subsequent Sheets the same data (if there is a date) should be added after the last entry in Sheet1.
Thank you for your consideration, time, and willingness to look at my problem. :)
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?