Hello,
I'm stuck trying to figure out what is the best method to get the following done.
as an example, lets say I keep records of homework assignments in an excel sheet.
<tbody>
</tbody>
Imagine that this is a very long list for the month of Nov. I could just keep adding records to this sheet and if I wanted to only see records for a specific week, I could just filter the results. What if I wanted to keep each week in a separate sheet BUT have the incomplete assignments carry over to the new sheet automatically?
I can only imagine how I want it to behave, I hope I can explain well enough. Here is what I need: Have the data automatically carry over, have it linked to the original source so that if I edit the source, and it goes from incomplete to completed, the data disappears from that new sheet. **A huge bonus would be if I can edit the data on the new sheet and have that update the source, in turn removing it from the new sheet, I don't imagine this is possible**. Now I have data from a previous week on my current week sheet, I want to be able to add data in the very next row. when one of the previous week's assignments disappears because it changed status, the data shifts up filling up the empty cell left behind.
is this possible at all or am I just dreaming?
I'm stuck trying to figure out what is the best method to get the following done.
as an example, lets say I keep records of homework assignments in an excel sheet.
| A | B | C | D | E | |
| 1 | Number | Class | Date Given | Deadline | Status |
| 2 | 16 | Trig | 11/11/2015 | 11/20/2015 | Incomplete |
| 3 | 7 | Bio | 11/22/2015 | 11/24/2015 | Completed |
| 4 | 11 | Soc | 11/26/2015 | 11/29/2015 | Completed |
<tbody>
</tbody>
Imagine that this is a very long list for the month of Nov. I could just keep adding records to this sheet and if I wanted to only see records for a specific week, I could just filter the results. What if I wanted to keep each week in a separate sheet BUT have the incomplete assignments carry over to the new sheet automatically?
I can only imagine how I want it to behave, I hope I can explain well enough. Here is what I need: Have the data automatically carry over, have it linked to the original source so that if I edit the source, and it goes from incomplete to completed, the data disappears from that new sheet. **A huge bonus would be if I can edit the data on the new sheet and have that update the source, in turn removing it from the new sheet, I don't imagine this is possible**. Now I have data from a previous week on my current week sheet, I want to be able to add data in the very next row. when one of the previous week's assignments disappears because it changed status, the data shifts up filling up the empty cell left behind.
is this possible at all or am I just dreaming?
