Move Row from one workbook to another based on value in column A

[torreyanderson]

I am new to VBA and have no idea where to start with this.

I have a workbook named "Active.xlsm" with one sheet also named "Active".

Each row is a job. When I finish the jobs I want to be able to change the value in Column A from "Active" to "Completed" and have the Row automatically moved to a different workbook named "Completed.xlsm" to the last row on a sheet also named "Completed".

Both workbooks are in the same location - R:\Jobs

The workbook called "Completed" will not be open when the macro is activated.

Thank you for taking the time to help me

 

[torreyanderson]

If it would be easier, a button to activate the macro would be fine. It would need to find and move ALL of the rows that show "Completed" in Column A as there would often be more than one done at a time.