Hi,

Can anyone help me with the below?

I have sheets named "Data" & "Cancelled". If i select column G as "Cancelled" in sheet "Data" the row should be moved to the sheet "Cancelled" and deleted from the "Data" sheet.