select and extract rows of data to new excel worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Have you tried Data>Filter>Autofilter then copy visible cells?

Or do you want a more automated method?


Gord Dibben MS Excel MVP
 
Back
Top