select and extract rows of data to new excel worksheet
 

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.

select and extract rows of data to new excel worksheet
 

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.