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 each lesson (tab) I have space for 2 dates (for the 40 minute classes), but for the 80 minute classes I will only use one date. In the Lesson tabs I also record attendance and homework.
What I'm searching for is a formula that can transfer the attendance and homework data (multiple cells) (+ the unit and lesson number cells) from a lesson to an overview sheet... but added to the overview sheet (same number of multiple cells) after the last recorded date.
So the formula should also search for the the last row with a date in the overview sheet, and then add the data in the following row below.
I hope my explanation of what I'm looking for makes any sense at all. Feel free to ask me for any other clarifications.
Thank you for reading, and in advance for those willing to help :)
Kind regards,
Martin
6 Replies
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 ! :)
