finding multiple broad terms in columns then pasting entire rows to new sheet

Cross post- from http://www.excelforum.com/excel-gene...new-sheet.html

I would like to find items in columns, then selecting entire rows for repaste in new sheet
After doing a find and replace search within column b on sheet1 for a broad term, ie *potato* all of the cells in column b will be displayed that contained in instance of potato, under cells will be $B$1, $B$246, $B$529, $B1000, etc
What I would like to do is select those entire rows and paste them in sheet2, and then go back and say search column b for *celery* and past after the potato containing rows on sheet1.

so
for ie
sheet 1
A B
1 potato soup
2 nothing here
3 potato flakes
4 something else
5 celery sticks

sheet 2 i want
1 potato soup
2 potato flakes
3 celery sticks

Thanks for looking!

As long as your data has a row of "titles" across the top of the data, specifically in the cell B1, then you can turn on the DATA > FILTER > AUTOFILTER and then filter that column by the term you want using the Custom option.

That makes it easy to see all the rows that "contain ... potato"...copy all the rows left visible to another sheet, then repeat for your next term, very simple. No macro really needed it's so powerful.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. Since this thread has already received an answer, your other thread will now be closed.

Manually filter by one or two items and copy the results over, then do your next filter. This only takes seconds, so should work for you.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.