Remove specific text rows and move to a separate sheet in a workbook

Hello,

I have a spreadsheet that I would like to identify a certain word string in a specific column and have those rows removed and placed in a separate labeled sheet in the same workbook

Sample attachment:

In the first sheet column F contains several cells that have this text "GST-P" I would like to have these rows removed from this sheet and moved to the sheet labeled "Remove GST Filing"

Any help would be greatly appreciated

Thank you very much

TEST.xlsx

Try

Please Login or Register  to view this content.

Thank you very much. It worked great. I added a few more filters to the code and the macro runs fine except at the end I'm getting the message "No Data to Remove" when there was data that was moved. I'm not sure how to edit this line to appear only when there is no action performed.

Here is the revised code.....
Thank you again.

Please Login or Register  to view this content.

No really sure how you want it...

Please Login or Register  to view this content.

That's actually even better. This works great. Thank you so much.