This seems (needlessly) complex if you are transferring (deleting/adding)
data between w/sheets. Why not have a status on workshhet1 to indicate
payment overdue (not yet paid) and/or late (paid but not by due date)?

"Jon" wrote:

In worksheet 1 A1 the contracting date of apartment, B1 payment date, C1
payment status (yes or no). If the contractor does not pay the contracting
money as per payment date, his data will be transferred to worksheet 2. And
if the status of the payment in worksheet 2 being yes, the contractor data
will return again to worksheet 1
Hop this is clear
And thank you a lot for your cooperation



"Toppers" wrote:

More information on what is required: for example, what is(are) the
condition(s)? And what data is in what columns etc

"Jon" wrote:

Hi,
I have two separated worksheets and I need to transfer data from worksheet 1
to worksheet 2 if condition is done. Can any body help me plezzzzzzzzz
Thanks!!