Consolidation Macro

Hi All,

I have 7 different workbooks that all contain the same headings in Columns A:H (only one sheet per workbook). I need a macro to loop through all seven workbooks, copy the data from A1 to Column H of the final row in that sheet (it varies in length), and paste them into my workbook on the "Master Sheet" tab. However, the data must be pasted at the end of the data that is already contained in the document, so I don't copy over anything. Also, if a file is not found, I want it to skip over it.

Can anyone help? I appreciate it.

I have few codes on consol, so to help you, could you please attache a sample workbook with desired output?

This is Jerry's code,not mine, but very flexible one.

Please Login or Register  to view this content.