How do I conditionally build worksheet from existing worksheet?
 

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.

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.