select and extract rows of data to new excel worksheet

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.
 
G

Gord Dibben

Have you tried Data>Filter>Autofilter then copy visible cells?

Or do you want a more automated method?


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query questions (I think) 4
I want to copy rows with values >0 to another worksheet automatica 4
Automatically Populating Worksheet from Collected Input for Pricelist 1
Select Case Statement 2
Populating worksheet via a drop down list ! 4
is this possible in excel 2007 3
criteria to filter and extract row data into separate worksheet 1
Hiding Specific Rows Based on Values in Other Rows 1

Top