Help please! Copy whole row if cell includes "x"

[jedibrown]

Hi,

Basically, I am creating some data and I am a bit stuck .

I would like to say:

If any cells in column c have the word "Giant" in it (there will be a sentance in each cell but I would like it to pick out the specific word) - Then please paste the whole line into sheet 2.

Is this possible?

Many thanks

 

[Andrew Poulsom]

You can Custom AutoFilter that column for contains Giant and copy/paste the visible rows.

 

[jedibrown]

Thanks - but I need it in a seperate sheet.

 

[JazzSP8]

Duplicate...

http://www.mrexcel.com/forum/showthread.php?t=611858

 

[jedibrown]

Sorry - I didn't realise I had made 2 as I couldn't find the original one at first!

 

[Andrew Poulsom]

Please continue in your other thread.