VBA for merging 200 excel files in one

[kypok999]

Hi guys,

I need simple vba for merging 200 files into one that i Have

they all start with same headers from A1 to Q1 lines can very from 300 to 500

all files are .csv format

Thank you in advance

 

[jkpieterse]

Re: Need simple vba for merging 200 excel files in one

No VBA required. That is a very simple task using PowerQuery or Get & Transform on your Data tab. Get Data dropdown, From File, From Folder.

 

[kypok999]

Re: Need simple vba for merging 200 excel files in one

Thank you i think it works that was easy!