Consolidation from multiple workbook with same name

[sarat47]

Hi Everyone

I have 200 workbooks in a folder (C:\Users\data).

I want to consolidate data of all workbook into a new workbook so that workbook name will appear in the new sheet.

e.g if workbook names are NGO_1, ctf_3 , dfs_S then the master workbook contain data with same sheet name as that of workbook (O_1, ctf_3 , dfs_S)

I found one macro from online but the sheet name is not named with workbook name.

Please Login or Register  to view this content.

[xlbiznes]

sound similar to this thread, have a look here.

http://www.excelforum.com/excel-prog...n-excel-2.html

[sarat47]

Thanks Xlbiz.
I am not able to understand what to populate in below two rows in sheet "My settings"
Condition u1 > 0
Specify Range U50:U50

I want to copy the 2nd row upto last row for all workbooks. Please guide what I need to change.

[Pepe Le Mokko]

This addin does all the work for you

[xlbiznes]

@sarat47,

if you have no condition then clear the cells next to condition and if you do not require any specific range then clear the cell next to specific range(leave them blank).

[sarat47]

Thanks to both of you for your support