Carring unused data forward to another sheet however starting in a nominated cell

[rustybenson]

Hi I have four colums of data on sheet 1 that represents first day of the month 1/5/2011 (AUST Date) with a list of shipments that have sales put uo to them. Each day the list is added to i.e. new shipments arrive and each day we seel from the oldest shipmet until it is sold and we move to the next shipment The days shipment data as below can occupy rows 13-26 Colum B-E

B c d E
Shipment No Litres On Shipment Litres sold From Shipment Litres Left to sell
13 123456 10000 10000 0
14 123457 15000 15000 0
15 123458 10000 5000 5000
16 123459 12000 0 12000

What I want to be able to do is the shipments that are exhausted (sold) are eliminated from the next days sheet and the ones that are not exhausted or have litres left to sell are transfered to sheet 2 (representing 2/5/2011) however starting in B13.
We can then add the next days shipments under the unused ones from yesterday.
So basically the shipments unused (or partialy used) from day one sheet are carried forward to day two sheet but starting in cell B13. Above example would become this next day sheet
B c d E
Shipment No Litres On Shipment Litres sold From Shipment Litres Left to sell
13 123458 10000 5000 5000
14 123459 12000 0 12000


This happens day to day untill month ends.
For the new month we carry the unsed shipments over manually.

I Hope this makes sense and I hope somene can help.
As always any help is appreciated.
Regards
Rusty

 

[rustybenson]

Thanks very much for your help. It is working fine.
Regards
Rusy