Home » Forums » Open Source Learning Center » Question and Answer

Combining Excel Sheets

Submitted by kleigh on 17 August, 2012 - 15:12

I'm looking for a way to combine multiple excel workbooks. I have 84 workbooks that have the same header information but in different columns. Is there a simple way to combine them all together instead of manually copying and pasting all of the data into a master file?

Thanks!

‹ Output Excel to Text can i set excel to automatically copy and edit data? ›
»
Nick's picture

Merge Data Sets

Submitted by Nick on 17 August, 2012 - 16:54.

have a look at this:
http://excelexperts.com/VBA-Tips-Merge-2-Data-Sets

»

Thanks so much! That is just

Submitted by kleigh on 31 August, 2012 - 18:47.

Thanks so much! That is just what I was looking for. Since I'm on a work computer I can't tell if its blocked, is there a download link at the bottom of the page?

Thanks

»
Nick's picture

The files to download are at

Submitted by Nick on 2 September, 2012 - 07:16.

The files to download are at the bottom

»