Conditional copy

L

ledzepe

Hi everyone,

On Sheet1 ColumnA, I got data that repeats itself and each row contains
.. For example:
apple data1
orange data2
apple data3
banana data4
orange data5
apple data6

On sheet2, I want to copy, from Sheet1, all rows with "apple" in column
A. The result would look like:
apple data1
apple data3
apple data6

Is there a way to automate this? The way I do it by AutoFilter Sheet 1
or by sorting it then do a copy and paste. Its a bit tedious because
this is a ten page document.
 

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

How to select values in sequence order? 3
conditional formatting for more than 3 conditions 3
Splitting data in a cell 9
Search/Sort Formula Help Needed 4
Transposing 2
Data import or transposing... 2
Copy lists and paste them automatically 4
Select to reference an other record or row 1

Top