Have you tried DataFilterAutofilter then copy visible cells?

Or do you want a more automated method?


Gord Dibben MS Excel MVP

On Mon, 23 Jul 2007 13:14:01 -0700, Cazstan
wrote:

I have a large pricelist. Want to estract all items containing certain word
in description like "wood" to a new sheet. This must be the entire row of
information as it is part number, description, cost and quantity etc.