Hi, I am looking to copy and paste multiple cells from "sheet1" in one workbook ("workbook1") to the last available row into "sheet1" in another workbook ("workbook1").
The cells I need to copy from workbook1 are A1, B4, C6:D8) and I would like to paste these into column A, C and D in the last available column in another workbook.
Please could someone help with the code for this? I am new to VBA. Thank you!
Bookmarks