auto filter / sort

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 sheet 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 worksheet, 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.
 
Jr,

Try using a pivot table: the values will sort, and you can simply display
only values >0 if you use an additional column with a formula that returns
TRUE / FALSE (along the lines of =C2>0) and use that as a row field.

HTH,
Bernie
MS Excel MVP

Jr said:
Hello,
I am trying to create a master order replenishment workbook. I have
Click to expand...
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 sheet 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 worksheet, 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.
 
Back
Top