I'm new to VBA so I was hoping someone could help me with my problem. GIVEN:
First excel file has X number of columns with Y rows
A B C D E (columns) 1 2 3 4 5 (row1) 6 7 8 9 10 (row2)
and 2nd excel has
A B C D (columns) 1 2 3 4 (row1) 6 7 8 9 (row2) a b c d (row 3) e f g h (row4)
trying to combine so it becomes A B C D E (columns) 1 2 3 4 5 (row1) 6 7 8 9 10 (row2) a b c d (row 3) e f g h (row4)
need it to loop combine for over 20 columns and 500 rows