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!
Other post URL http://www.excelforum.com/excel-prog...new-sheet.html
Bookmarks