Copy paste to different tab base on condition

Hi,

I want to minimise the manipulation of a data excel file, so I am wondering if anyone can help me out with this:

1) Scanning from C2 to last row: If C2 = GAME 1, then it will copy the rows to another worksheet called: "TAB GAME 1" then until last row.

2) It will then repeat but for another condition such as: If C2 = GAME 2 then it will copy the rows to another worksheet called "TAB GAME 2" then until last row.

Thanks.

Maybe:

Please Login or Register  to view this content.

Hi,

Thanks for you guys code, however, I made this but it works only for 1 cell. How can I change it so it can work for the whole row?

Please Login or Register  to view this content.

I guess I found it..I can use the following:

Please Login or Register  to view this content.

Please Login or Register  to view this content.