Consolidating Multiple workbook in to one sheet

[webmax]

Hi,

I have a multiple excel workbooks. I want to consolidate all the workbook in to one sheet.

can you provide the macro code

regards
shahul

 

[Marc L]

Hi !

All is yet here : Consolidate data from different excel files (VBA) …​

 

[mdfreeman]

If this is a regular thing you are doing check on the resources on this page along with the addin that Ron de Bruin has created.

Coding resources: https://www.rondebruin.nl/win/section3.htm
Addin: https://www.rondebruin.nl/win/addins/rdbmerge.htm

Mark