VBA to Merge Sheet1 of Multiple Workbooks in Same Folder

[kendalldev]

I see a variety of code for what I am looking to do. Ron de bruin's code is almost exactly what I need, but need help with part of it as the row range must be dynamic.

I have 20+ workbooks with different names in one folder. I need to stack the data from each workbook into one worksheet in a master file. Ideally, headers would only appear once.

- Columns remain the same but row count is different in all files
- First two columns contain merged data, so an unmerge and copy/fill function may be necessary.

Hopefully that's enough info. Thanks in advance.

 

[vanthinh3101]

I see a variety of code for what I am looking to do. Ron de bruin's code is almost exactly what I need, but need help with part of it as the row range must be dynamic.

I have 20+ workbooks with different names in one folder. I need to stack the data from each workbook into one worksheet in a master file. Ideally, headers would only appear once.

- Columns remain the same but row count is different in all files
- First two columns contain merged data, so an unmerge and copy/fill function may be necessary.

Hopefully that's enough info. Thanks in advance.

Can you post your file or link to file?