Not quite sure where best to place this so I’m placing it here as it might end up
as a coding solution in a bit of VBA script.
Doing something in Excel and I have to admit I’m more of a Lotus 123 peep.
Anyway I’m sort of after a solution to my need’s… in essance I was looking
for some form of a calculation loop but cannot find anything that kind of acts
that way.
Basically I have like an onhand Stock Figure and in addition a safety stock figure.
Now to add to that I have consumption and batch sizes for a pallet of stock and other odds and sods factured in.
I was wanting a loop as such to increment the amount of pallets needed
facturing in everything to basically increment upwards until a condition is true.
So I wanted something sim to coding a while loop
i.e. while x < y make cell z = z + 1 until x > y
If you programming geeks get me drift
So Question is any excel bod’s here that can point me down the right route
to my best way.
i could be over complicating it and there maybe a far easier route but a loop
is how I kind of have it pictured in me head.
Thanksie
/Paul.