Change sheet data

[r-simard]

Hello,
I am working on a shared document for pre-hire process follow-ups.
I would like to find out how to make sure that the data from line A6 (exemple) of sheet 1 (file in progress) is automatically transferred to sheet 2 (Completed) when I enter YES in column J. I want all the information from line A6 to be transferred and not copied to the second sheet.

Thank you

[#2]

Hello @r-simard,

Check this out>> DATA ENTRY 

[#3]

@Rr_ 
Hi , 

I think i didn't make myself clear. 

I want my data  switch sheet , when i select oui 

Pass to en progres to Completé APTE

And then be automatically transfert and earese from page en progres