Hey all.

Im really having big problems with my excel simulation and Im hoping one of you might be able to help me.

Simply said, In my simulation i have a decreasing inventory which, at 30 units, increases by one months average inventory. I use Crystal ball to simulate this, and what I want is for CB to take the ending inventory and use it as beginning inventory for the second simulation run, and so on...

How do I do this without creating a circle reference? Is there any way of excel "remembering" the ending inventory and using it as beginning inventory?

Thanks in advance,
Jan Ivar Cz.