auto filter / sort

From: Jr (alamo(deletethis)_at_2fords(notneeded).net)
Date: 05/31/04 

Date: Mon, 31 May 2004 14:51:05 -0700

Hello,
  I am trying to create a master order replenishment workbook. I have created a list of all the items we keep in stock by their location in our store. I would like to be able to sort this master list into several vendor specific lists. I would like to be able to input an on-hand count into the master *** and it would be compared against other variables to determine if we need to place an order. If the on-hand count for an item warrants a "suggested" order, the recommended value would be copied to a field on the vendor specific list approrpiate to the item. I would then like to sort the vendor specific list for any item with a greater than zero value in the designated column and print only those rows which meet the >0 criteria. I am a novice. I do not know if all of these functions can be performed on one work***, How to perform the sort by Vendor Name to copy all the rows into each vendor specific list, or how to print only the desired result. A nudge in the right direction would be a big help.
thanks.