Button that will copy cell to different workbook into rows with same ID

Good day, everyone.

Is there a way to copy the contents of a column to a column of a different workbook, making sure to copy each cell into the row that matches the ID on the source workbook?

For example, in the attached Sample_Source file, I need the data on Column B (Overall) to be transferred to Column E (info) of the Sample_Destination file. The ID number needs to be matched before the copying takes place. For example, in the samples, B2 in Sample_Source should go to E17 in Sample_Destination. E17, after pressing button, will now display 4.

After that, the contents (except headings) of the Sample_Source file should be deleted.
The next time someone inputs data in Sample_Source, the button will do the same thing and look up the new ID numbers and add their Info to the same Sample_Destination file. All ID numbers are unique. The number of rows with contents that need to be transferred varies from time to time.
The button should be in the Sample_Source file.

Is this possible to do via VBA?

Thank you for reading!

Sample_Destination.xlsx
Sample_Source.xlsx

Hi michaljireht

Do you wish ONLY the Matches to be deleted from Sample_Source or should ALL Data be deleted, regardless of a Match?

Hi michaljireht

This Code is in the attached Sample_Source Workbook. Sample_Destination can be open or closed. If closed the Code will open it. For testing purposed place both Workbooks in the SAME Folder. ALL Data is cleared from the Sample_Source File.

Let me know of issues.

Please Login or Register  to view this content.

Hi michaljireht

Sure, this can be done

Is there a way to delete only the matches in the Source Sheet

Create a Sample File that exhibits no matches and upload it. The Code will take a bit of rewrite and I'll need something to test the Code.