Moving rows to another sheet and keeping the rolling number

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.

Try this one.
Put the code in the sheet "Data" .Right click the data sheet, view code-copy and paste the code. And change the value of G and will see the result.

Please Login or Register  to view this content.

Thanks it worked.