Re: auto filter / sort

From: Bernie Deitrick (_at_)
Date: 06/01/04 

Date: Tue, 1 Jun 2004 08:04:53 -0400

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" <alamo(deletethis)@2fords(notneeded).net> wrote in message
news:D79603D4-81CF-450B-8872-32B238AA2C3D@microsoft.com...
> 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.