How to summarise a Order Form

[Guest]

I have created a simple list of items that is used as an order form for the
goods we supply. The list is organised in such a way a to be easily navigated
when placing an order but the items are actually located in many different
places. I wish to create additional summary sheets for each location that
show just the items that are kept in that particular place. I am familiar
with the 'IF' command but not sure if that the best command to use for this
particular task. Any assistance would be much appreciated.

 

[Guest]

Hi John

There is no reference to the actual storage location on the Order Form
itself as it is not relevent to the purchaser when placing order. The
additional 'Location Sheets' would be hidden from the purchaser, for recovery
when we process the orders. We could perhaps add some form of identifier to
the product code to assist sorting? At present the Order Form we use is made
up of 10 sheets within a workbook with 1 hidden summary page for the whole
order. At present the goods are essentially stored in 1 place so sorting a
requisition is easy, but soon there will be 4 different locations and we wish
the 'sorting' to be done automatically to ensure accuracy and speed. On the
current summary sheet we use the 'IF' command to determine whether the item
has been ordered or not and therefore shown, however the problem for us is
how to direct orders on the Order Form to specific summary sheets. I hope
this all makes sense.
Thanks
Grahambio