Forum Discussion

William Landing's avatar
William Landing
Copper Contributor
Aug 17, 2018

Merging complicated Excel files

I have 3 Excel files that each have 69 sheets, and the data in each sheet occupies 3 columns. I want to merge them into a new file so that the data in each sheet is listed like this: 

Newfile Sheet 1

File 1, Sheet 1       File 2, Sheet 1      File 3, Sheet 1

Col1  Col2  Col3   Col1  Col2  Col3   Col1  Col2  Col3

 

Newfile Sheet 2

File 1, Sheet 2       File 2, Sheet 2      File 3, Sheet 2

Col1  Col2  Col3   Col1  Col2  Col3   Col1  Col2  Col3

 

Et cetera for all 69 sheets. Copy/paste will take too long! Any ideas? I have zero VBA capability.

No RepliesBe the first to reply

Resources