Thread: Copy data from one table to another depening on value from cell

Hello forum!

I have two tables with the following names: Rewatching and Rewatched.
They are for my anime list in which I keep track of my current shows I am watching. It sometimes happens I watch one show just one more time, or twice.

In Column G there is a formula, which can have certain outcomes. Only on one condition I want to move data from the Rewatching table to the Rewatched table. The condition is when the value in column G in the Rewatching table = "Completed".

The attached example has the explanation added, which could make it more easier to understand.
I used row A10 as an example. Below this row is the explanation I would want the code to do.

I hope you can help me with this!
If I'm not clear enough, please ask!

Kind regards,

Marco