Hi guys, basically i am creating an inventory where it simply says how much stock is remaining so I know when to re-order. At present i got a function added so that if a value of stock is 1 or below the rows will highlight.
What I want to do is create another sheet where the information from the stock amount page automatically transfers into a clear page so that I can see what needs ordering.
Im a newbie so all this is very confusing and I dont have a clue where to start for this particular thing.
I have attached two pictures for you all to see. Any help will be greatly appreciated.
Main page:
\1
What needs ordering page:
\1
Bookmarks