Hi Guys,
i have created a stock sheet on Sheet1, i have say 100 items and each item has a min and max stock order.
once the item hits a min low, the last cell (O) will display an order needs to be placed.
I was wondering if there way a way that on sheet2, it can calculate all the data on sheet1 and if there is stock that needs to be ordered, it will appear on sheet2?
This way i can just print sheet2 and send it to the supplier without having the entire 100 items displayed -if it does not need to be ordered?
sorry if there is a thread relating to this, im not actually sure how to even begin looking for a question similar.
Thanks in advance
Bookmarks