Forum Discussion
William Landing
Aug 17, 2018Copper Contributor
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