move a row to another sheet and separate workbook based on cell value with button

wheellp

New Member
Joined
Aug 2, 2016
Messages
27
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!
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Watch MrExcel Video

Forum statistics

Threads
1,113,892
Messages
5,544,893
Members
410,643
Latest member
sng
Top