How to move whole raw to another sheet when the cell has a several status in Excell 2013

Hi All,

I would like to kindly ask you all for help.

I am doing a self study in VBA and macros. But can't solve this up to now.

I have a xls file, with a list of claims in the first sheet where are different statuses, whereby I would like to manage it to be copied into correct sheet (when status rejected copy the whole raw into the sheet rejected claims), to avoid the manual work.

Many thanks in advance.

Status Legend: Rejected --- sheets are the same as statuses
Withdrawn
Completed
PFI

Fields in the raw: No./Country/Link/Claim#/Type/Distributor/BP/EU/C/CA/status/CR/EUR/Summary/Result/Status/Last action/CC support/Reg. Date/Last date/TAT

Can you maybe post a workbook with some sample data and a visual indication of what you want? I'm a bit confused by your explanation.

tracking system.xlsm

Hi,

hereby I attach the xlsm file where I was trying to do that.