Issue copying data from one workbook to another

Hello,

I have two workbooks, a Source workbook and a Destination workbook. I need to pull data from in the Source workbook and paste it into corresponding columns in the Destination workbook.

When the column headers in both the Source workbook and the Destination workbook appear in row 1, the following macro works great.

Please Login or Register  to view this content.

However, the actual workbooks I'm working with contain extra rows and columns. For example, column headers in the Source workbook appear across row 2. Column headers in the Destination workbook appear across row 4. To complicate matters, the Destination workbook contains extra rows at the top, a blank row between the header labels and the first row of data, and extra blank columns across the worksheet. See attached Source2 and Dest2.

I can't figure out how to modify my macro to account for these extra rows and columns.

Thanks in advance for helping me solve this problem.