VBA button to move a range of data

[Closed]
Report
Posts
1
Registration date
Wednesday March 1, 2017
Status
Member
Last seen
March 1, 2017
-
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.