Merging of columns from multiple workbooks into one worksheet

[rajani85]

Hello All,

I have multiple workbooks inside that multiple worksheets are available, i wanted to merge all the worksheets data into one excel file.
Ex.
Book1
A B C
5 1 7
4 5 8
4 6 9
2 9 7
6 10 4
9 10 4
10 10 10

Book2
D E F
55 59 56
57 54 59
53 54 50
60 56 51
51 53 52
55 56 56
58 60 50
60 52 56
51 50 50
53 53 52
55 54 50

OutPut should be

A B C D E F
5 1 7 55 59 56
4 5 8 57 54 59
4 6 9 53 54 50
2 9 7 60 56 51
6 10 4 51 53 52
9 10 4 55 56 56
10 10 10 58 60 50
60 52 56
51 50 50
53 53 52
55 54 50
Could you please help me resolving this issue. Many thanks in advance.

Best Regards,
Raj

[JOHN H. DAVIS]

Maybe something like this with all workbooks open:

Please Login or Register  to view this content.

Untested but should merge all the sheets of all the workbooks into Sheet1 of Workbook1.

[rajani85]

Hi John,

Thank you for your response. Please see the below image for the output (O/P) of your code.

Along with that, i have provided my requirements in the same image for your better understanding
Input (I/P) File 1: Which is my first file
I/P File 2: Which is my second file
Desired O/P File: Which is the merging of all the used columns of both the files (I/P File 1 & I/P File 2)

Many thanks in advance.

Kind Regards,
Raj
Merging of Columns.jpg

[YasserKhalil]

Thanks a lot Mr. John for this great code
I have edited a little to suit OP request

Please Login or Register  to view this content.