Is it possible to ask excel to look for a specific phrase then copy the
rows that contain that phrase and then paste the rows into a new
worksheet?

So . . .

In column A I have:

1 blue sand shoes
2 blue canaries singing
3 blue canaries wearing shoes

In this example excel would copy and past rows 1 and 3 into a new
worksheet.

If that's too complicated could it find the cells containing blue and
shoes and copy the contents of those cells into a new column?

Thanks for your help
Gillian


--
gjpcoach
------------------------------------------------------------------------
gjpcoach's Profile: http://www.excelforum.com/member.php...o&userid=31900
View this thread: http://www.excelforum.com/showthread...hreadid=516279