moving all correct records into one sheet and wrong records into one sheet

Hi Friends,

I appreciate your efforts in the team.

I attached one sample excel procedure that is extracting data from source sheet to target sheet. Now I want to extract all the correct records into one sheet and all the wrong records into one sheet (If there is any wrong records such as errors that may null values, wrong dates).

All correct records needs to be stored in worksheet("11514SD") and for wrong records needs to insert new sheet and store in it.

If we click on command button on in source sheet two sheets need to load one with correct and another one with wrong records.

Please kindly refer my attached worksheet and give me appropriate solution.


Thanks & Regards

Rams