Hi All,
I'm looking for some help programming an "order sheet".
Although I've been creating basic spreadsheets for a couple of decades (I go back to using LOTUS 123), I'm having trouble understanding whether I can achieve my needs through a simple (or not so simple) formula.
I have a rather extensive order sheet. the columns are typically Item Name, Unit Size, Inventory, Par Stock, Order Amount, Remarks.
Since there are hundreds of items on the order sheets but only a few dozen ordered at any given time, I was hoping to create a tab in the work book which would print out Item Name, Unit Size AND Order amount ONLY, for those items which have a value in the Order Column.
Is this possible? How complicated is the formula (if that is indeed what it is).
All help is much appreciated.....
Bookmarks