Combining multiple files in Excel

[sameep.sanghrajka]

Can anyone show my how to combine multiple files (189) with the same
number of columns into one master excel spreadsheet.

Thanks.

 

[Ron de Bruin]

Start here (code and add-in)
http://www.rondebruin.nl/copy3.htm

If you have suggestions for the add-in post them.
I will update it when I have more time and suggestions are welcome