I have identical Tables, one is called Active and one is called Completed. They are on separate Sheets, also called Active and Completed.
In column H there is an option to select the status. When someone selects "Complete - No Further Action Required" i would like it to move (then delete) this row from the table and add it to the Completed table.
Any help on a VBA to do this automatically?
In column H there is an option to select the status. When someone selects "Complete - No Further Action Required" i would like it to move (then delete) this row from the table and add it to the Completed table.
Any help on a VBA to do this automatically?
