How do I conditionally build worksheet from existing worksheet?

[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.

[Tom Ogilvy]

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

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

--
Regards,
Tom Ogilvy

"Bob G" <Bob [email protected]> wrote in message
news:[email protected]...
> 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.