I discovered another thread close to something I am trying to do. Automatically move a row to another sheet based on cell value
I am trying to do pretty much the same thing but with a button and with the copied data from columns A-M only going to 3 places at once, another sheet in the same workbook and 2 sheets in a different workbook in a different location.
In Sheet 1 (Profile Requests in progress) I have data in columns A - M. Column K shows a status with a drop down list, "Complete" is selected from a drop down list currently.
I want my spreadsheet to cut and paste 'complete' rows into sheet 2 (2020 Completed) AND another workbook (Profile Request Tracker Report AUTO) in the sheets "Current Year Complete" and "All". The other workbook located in the following location L:\PROFILES\Reporting. Deleting the data from the original sheet. Let me know if I can provide any more information. Thanks for any help!
I am trying to do pretty much the same thing but with a button and with the copied data from columns A-M only going to 3 places at once, another sheet in the same workbook and 2 sheets in a different workbook in a different location.
In Sheet 1 (Profile Requests in progress) I have data in columns A - M. Column K shows a status with a drop down list, "Complete" is selected from a drop down list currently.
I want my spreadsheet to cut and paste 'complete' rows into sheet 2 (2020 Completed) AND another workbook (Profile Request Tracker Report AUTO) in the sheets "Current Year Complete" and "All". The other workbook located in the following location L:\PROFILES\Reporting. Deleting the data from the original sheet. Let me know if I can provide any more information. Thanks for any help!
