Change sheet data

Copper Contributor

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 Replies

Hello @r-simard,

Check this out>> DATA ENTRY 

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