Append

[arnoldmiranda]

Hi,
I have 11 excel files with dat in them, can someone help with a macro that can copy paste all the data from the 11 files on below the other in the master file. The colums are all identical however the amount of data (ie rows) may vary....this file is truly huge 50 to 60 mb

Thanks
Arnold

 

[VoG]

Hi. See if this helps http://msdn.microsoft.com/en-us/library/cc837974.aspx