How to move a row from one table to another when the is edited

Question

I have a table  that maps an IP-address to the mac-address. To keep it clean I want to seperate the table into two. One with the used IPs and one with unsused IPs. My question ist, whether there is a macro to move a row from the table with the unused IPs to the other table once a mac-address is filled in.

Patrick Vanhoof · Answer

Sorry, no idea if you can automate that...

Connor Kolan · Answer

I know that, but in my experience, the 5 second it takes to cut, paste and delete the old line, are the 5 seconds, that keep people from maintaining the table properly.

Patrick Vanhoof · Answer

There is an option to cut (or copy) and paste a row when you are inside a table: