VBA - Copy and Paste Table Data (without headers) from one workbook to another

[JamesJones25]

Hello,

I need to copy and paste just the table data (not headers) from one workbook into a different existing workbook which I'm calling with that commented out "OpenBook" Module. Both existing tables are in the same format with same # of columns but the source book will have more rows than in the table range of the destination book - of which I'm trying to overwrite

This is what I've been trying but run into a "Subscript out of range" Error 9

Any help is much appreciated!

 

[Peter_SSs]

When posting code, please copy/paste the actual code rather than a picture of it. That way, helpers can copy and test with it without having to manually re-type it (probably with errors).
My signature block below has help about that.

Subscript out of range would indicate that Excel cannot find an open workbook with one of those two workbook names or else it cannot find the correct sheet name in one of the workbooks.

In any case, assuming both workbooks are open with correct sheet names, your two lines of code need to be a single line.

Workbooks("File.xlsm").Worksheets("Transformed Table").Range("A3:F9999").Copy Workbooks("NewFile.xlsx").Worksheets("NewTable").Range("A3:F9999")