Combine data from multiple excel workbooks

[matthewpaul12]

Hi,

I have 60 excel files that each contain data for one day of the last 2 months. They are identical formatting wise, although they obviously contain different rows of data. Is it possible to combine all 60 excel files into one document? In other words, I'm just just trying to get the data rows to build on top of each other in one file.

I'm just trying to avoid the obvious method of manually copying and pasting 60 times into the same file.

Thanks!

 

[Norie]

Where are the files located?

If they are all in the same folder then you might be able to use Power Query to combine them into one.

To do that select the Data tab and in the Get & Transform Data section select Get Data>From File>From Folder... and then Browse to the folder holding the files.