How do I conditionally build worksheet from existing worksheet?

B

Bob G

I want to build an inventory worksheet that contains only the items whose
amount on hand is less than a specified number. I know the answer is in the
Help somewhere but I haven't had any success in finding it.
 
T

Tom Ogilvy

Look in the menu at Data=>Filter =>AutoFilter

Use a custom filter on the quantity column and set up your criteria.
 
Top