Hello Jarrod,

You don't need to use Copy and Paste. VBA can transfer the data from one workbook to another for you. It would be easier to help you do this if you can post your workbook.