torreyanderson
New Member
- Joined
- Feb 26, 2021
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
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
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