Macro to copy rows if detects a specfic key word

Hi again, I attempted at manipulating a similar macro but I just can't get it to work. I'm a novice with coding so I can't troubleshoot the problem. Hope someone can help out.

Please Login or Register  to view this content.

Bump, can anyone help?

Im pretty new to vb also but just something I noticed, you have used rCell but not defined what it is exactly however you have Dim'd it as a Range

Not too sure if this helps.

Hey, emm I'm new to vba as well, a complete novice if I'm honest. What it is that I tried manipulating an existing macro I found on Google, that was used to move rows from other sheets. But I'm trying to move rows within the same sheet depending on a specific criteria.

Im not on a computer right now. Ill try later

Cheers mate, heres the spreadsheet if it helps

Test Spreadsheet.xlsm