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 wrote in message
...
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.