Conditional copy entire rows if cell value meets criteria - Excel VBA

[CakzPrimz]

Dear MrExcel,

In sheets "Data" I want to copy entire row only if cell value in column F, contents these string arrays, regardless the words in Upper case, Proper case or Lower case).

- Cement, it could be Type 5 cement, Cements, etc
- Spun
- Concrete

Copying entire rows into sheets "Collector" starting in row number 3.

Thank so much.
prima

 

[YantiPrima]

No problem with the pasting start row. The only problem is the header in "Data" sheets is repeated copy into "Collector" sheets.
Anyway, still I can use your magical code without any problems at all.

Problem solved !!!

Again, I really appreciate for your time and helping hands.

Thank you
prima

 

[My Aswer Is This]

I just tested my script again and the header row is never copied to the collector sheet.

Normally most people refer to Row(1) as the header row.
What row is your header row?

 

[My Aswer Is This]

Does your header row column F have one of the key words we are looking for?
And again what row is the header row

 

[Peter_SSs]

Dear Peter,

I have tried to apply your code, but no record to copy at all to "Collector" sheet.
And I do not know the reason why.

Really appreciate for help and kind attention

Thank you
prima

This thread was started by CakzPrimz. You are responding as if it was you who asked the original question. Please refer to my private message to you about that issue.