Hi Again
I was hoping you could help me with a formula problem i am having.
Having set up a new stationary ordering system i am wanting to have the order form automatically populate with the order amount needed if the stock falls below a certain level.
I have attached a copy of the spreadsheet we have at the moment and what i would like is in the stock control tab (Yellow) when the stock remaining (H) falls to or below the minimum allowance (I) it populate on the Order sheet column E the order quantity as specified.
I have tried a couple of simple variations but nothing has worked so far.
Any help would be greatly appreciated
Thanks
Su3b3a
Bookmarks