VBA to copy and paste data in a changing worksheet

[ChrisTacoma]

Hello, I am new here and new to VBA.

Also, have not been on a forum before...

I am having trouble with a copy and paste function in VBA. I have it set up to automatically run when we open the file; however, the code runs the entire worksheet again making redundant copies of the data.

What i would like to occur is, when we open the file and the code automatically runs, to only copy and paste only the changes made to the original worksheet.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Capture.JPG

Thanks in advance!

[JLGWhiz]

You might want to try using a different event, like Worksheet_Deactivate instead of the Workbook_Open. That way after the changes are made and the worksheet is closed it will call the code to save the changes. To accomplish this, Install the code below in the Worksheet code module of the sheet where you want to save the changes. Right click the sheet name tab, click 'View Code' in the pop up menu, paste the code into the code pane of the vb editor. Close the editor and then double click 'ThisWorkbook' in the Project pane of the editor to open the workbook code module and delete the workbook code. close the vbeditor and click the save button. The code should now run when you leave that workbook page.

Please Login or Register  to view this content.

If you mean that you only want the changes to be copied, and pasted then you would need to use Worksheet_Change event that would execute as each change is made. But that event will not recognize changes resulting from Excel calculations.