VBA button to move a range of data

Closed
Minatrea Posts 1 Registration date Wednesday March 1, 2017 Status Member Last seen March 1, 2017 - Mar 1, 2017 at 11:16 PM
Hi. So, here's what I would like to do:

Excel Workbook (Cert_Master) local
1. I enter various information about a job into Worksheet (DATA); it populates a Certification in Worksheet (CERT) and a Log Entry in Worksheet (LOG).
2. I would like a button in Worksheet (LOG) that sends a range (A2:N2) of VALUES (not formulas) to the following Workbook.

Excel Workbook (Master_Log) on network drive
1. The incoming data would populate the next row down in the Worksheet (LOG). It would NEVER overwrite data, and would ideally save the Workbook (Master_Log) after the new data is populated.

Right now it is a cut and paste process, but an automated process would save me a ton of time each day.

I usually keep both Workbooks open at the same time.