Consolidate A specific sheet into new workbook

[Swalih]

Hi all,

This is my first question. Kindly accept my apology in case of any mistakes.

I have more than 100 excel files in a folder. Each file has 4 worksheets namely "PENDING","Home","Dump" and "Function". All i want to do is to consolidate the data in "Dump" sheet from all files to a single worksheet. Please note that the structure of the data is same in all the files( The number of rows may vary ). Can anybody help me?

 

[SirJB7]

Hi, Swalih!

As a new user you might want (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, do you think that you can manage to handle the fixes to this link? It has a very similar if not equal issue:
http://chandoo.org/forum/threads/co...he-next-spare-row-using-vba.14107/#post-83797

Just advise if any issue.

Regards!

 

[Swalih]

Hi, Swalih!

As a new user you might want (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, do you think that you can manage to handle the fixes to this link? It has a very similar if not equal issue:
http://chandoo.org/forum/threads/co...he-next-spare-row-using-vba.14107/#post-83797

Just advise if any issue.

Regards!

Thanks SirJB7,

i am not able to do the fixes :-(

 

[SirJB7]

Hi, Swalih!
If I find the required time before the weekend I'll get back to you, otherwise on Monday I guess.
Regards!