I think I maynot have explained this clearly... Here us a better example
what I have and what I am trying to do... I have units leaving and and
coming in. I need a way to allocate. Going by the table below... I want
to be able to change Joe's ShipDate to 6/25 and see how it affects the
OnHand Units. This way I can look at everything, change a few ship
dates and be able to accomidate more customers. Make Sense? Thanks
again for all the help... If I can get this working it will save me
hours and hours of work.


Rep ShipDate Qty OnHand
Joe 6/9/06 -1128 1200
Matt 6/9/06 -372 72
Jim 6/15/06 -150 -300
John 6/15/06 -6 -450
Sam 6/15/06 -12 -456
DELIVERY 6/15/06 4210 -468
Adam 6/25/06 -288 4678
Joe 6/25/06 -897 4390
---------------------------------
Total 6/25/06 3493


--
rainxking
------------------------------------------------------------------------
rainxking's Profile: http://www.excelforum.com/member.php...fo&userid=9431
View this thread: http://www.excelforum.com/showthread...hreadid=542183