Working Backwards with Production and Shipments

[JamesB]

Hi all,

I was just wondering if anyone could help me with this problem,

I am trying to work out how to get a column in my spreadsheet that will work out (backwards) which shipment we are producing for at the corresponding date

I have the sheet set out as follows:

A B C D E F
Date Prod InStock Shipped Ship ForShip


As there is no regular interval between shipments, I need something that can start at the bottom and work its way up by looking at D (shipped) and then subtract each days production from this until it reaches zero,all the time putting the ship name in F (ForShip). Then once it reaches zero, I need it to go back down to one cell above the previous D cell used and repeat, continuing the subtraction from the date where the previous calculation reached zero!

Way to hard for my little brain.

I am not very good at code but will try anything! (thats if anyone even understood what the heck I am on about!)

Thanks in advance!

 

[vconfused]

Did you figure this one out?

 

[fairwinds]

Hi,

Why did you wake this oldie up?

Same problem?

Book1
	A	B	C	D	E	F	G
1	Date	Prod	InStock	Shipped	Ship	Shipped	ForShip
2	2004-10-10	100	100			0	Sea Hawk
3	2004-10-11	100	200			0	Sea Hawk
4	2004-10-12	100	300			0	Sea Hawk
5	2004-10-13	100	400			0	Sea Cloud
6	2004-10-14	100	500			0	Sea Cloud
7	2004-10-15	100	600			0	Sea Cloud
8	2004-10-16	100	400	300	Sea Hawk	300	Sea Cloud
9	2004-10-17	100	500			300	Sea Cloud
10	2004-10-18	100	600			300	Titanic
11	2004-10-19	100	700			300	Titanic
12	2004-10-20	100	300	500	Sea Cloud	800	Titanic
13	2004-10-21	100	400			800	Titanic
14	2004-10-22	100	500			800	QE2
15	2004-10-23	100	200	400	Titanic	1200	QE2
16	2004-10-24	100	300			1200	QE2
17	2004-10-25	100	400			1200	QE2
18	2004-10-26	100	500			1200	QE2
19	2004-10-27	100	0	600	QE2	1800	QE2
Sheet1