VBA Macro to Merge multiple files in a folder

[Devendra.dvm]

Hi Experts.

I have several individual workbooks in one folder and all are contains one sheet only, range is different. I want to merge all workbooks(Huge data) in one master file.

For example: path folder contains 5 files and if sheet1 cells exceeds the limit in master file after merging “one file or Half file” it should continue merge remaining data in from sheet2 in master file.


Please help me on the same…Thank you in advance.

http://chandoo.org/forum/threads/vba...-folder.33561/

[davesexcel]

I have a you tube example.

Loop Through A Folder

As far as completely filling up a worksheet with data, if that does happen, you may need to rethink how you want to store your data

[Devendra.dvm]

Hi Davesexcel

thanks your reply..i have gone through that link but my requirement is different.