Copy Table, Paste to Another Table , Delete the Value rom original table base on the condition value

[xeonavn]

As stated in the subject, is that possible? Ex.

1. I want to copy all the value from column A base on the Input ID.

2. then paste to another table.

3. will be deleted all the copied value from the original table.

4. This event will trigger base on the status of the value.

Appreciate all the suggestions.

Thank You!