How to carry on data to new sheet based on criteria?

[jongar]

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.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Number[/TD]
[TD]Class[/TD]
[TD]Date Given[/TD]
[TD]Deadline[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]16[/TD]
[TD]Trig[/TD]
[TD]11/11/2015[/TD]
[TD]11/20/2015[/TD]
[TD]Incomplete[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]7[/TD]
[TD]Bio[/TD]
[TD]11/22/2015[/TD]
[TD]11/24/2015[/TD]
[TD]Completed[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]11[/TD]
[TD]Soc[/TD]
[TD]11/26/2015[/TD]
[TD]11/29/2015[/TD]
[TD]Completed[/TD]
[/TR]
</tbody>[/TABLE]

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?

 

[Copan1795]

Is the info that will change coming from a another excel sheet? if not ,Try to put = in the cell that needs to changed Sheet1 ,then go to sheet 2 where the info is coming from and sheet1 should change every time you change sheet2.



Copan

 

[jongar]

Can you elaborate a little bit more? im a little confused

 

[jongar]

you or anyone else**

 

[jongar]

bump

 

[Copan1795]

Sorry after you go to sheet2 and the info go want to go sheet1 hit enter. You will have to go cell by cell.

Copan

 

[jongar]

gotcha, unfortunately it doesn't fit my needs. I need something more automatic. Anyone else has any suggestions?