Date of Receipt based on In/OUT

HI all---- (Altered post to try and explain further)

Looking for some help, Think Ive bitten of more than I can chew with this one!!!


I have two worksheets, one contains Yesterday information - Stock and Date of receipt, the other contains todays information without Date of receipt.

I need to update the todays worksheet with Date of receipt information from the yesterdays Sheets.. sounds simple?

The problem is im working on an aging profile for stock (done manually at the moment) and the Todays sheet has a total quantity per part where as the Yesterday sheet has the part broken down to show the date of receipt by quantity.

For example
Part number A has one entry totaling 20 pcs on Todays Sheet but has 3 entries on yesterdays 10, 5, 5 = 20 in total. The three entries have different dates of receipt.

I need to update todays sheet to split Part number A into the three entires with the 3 dates.

As this is a aging profile Im working on I also need to factor in any shipments

For example
Part number B has one entry totaling 10 pcs - Yesterdays sheet has 3 entries 5 (DOR 01/12/2009), 5 (DOR 01/01/2010), 5 (DOR 20/01/2010) = 15 each with different dates

I need to ignore the oldest entry on Yesterdays sheet (as the oldst part has shipped, therefore Todays sheet would only show 2 entries of 5 with the 01/01/2010 & 20/01/2010


Also if a part is on TOdays and not on YEsterdays sheet then automaticaly enter todays date.

Also if a part is on yesterdays but not on Todays then add that part to todays to allow for output calculation...

Any help/ideas would be appreciated.......Ive been through the site gathering snipets of code, but not really sure where to start to put it all together!