Merging two tables with different column number.both tables have some column common name

If I have two tables for example the first one has 11 columns and the second one has 6 columns (and the 6 columns names already exists in the first one).

SO I need to join or merge the two tables to have the two tables in one table even If I have 5 blank columns for the second one.

to handle it for a small tables it is easy but for more than 300 row, I want to do it automatically using a macro or

Are you comfortable with VBA solution? All you have to do is press a button and all will be updated.

Yes of course it ok to do it with VBA or formula

Try the attached.

Thanks a lot for your effort. God bless you
That's exactly what I need

Hello,

I've tried to use the same code on two bigger tables each table is locates in a different sheet and t combine them in a third sheet.


I always get error 1004

Please Login or Register  to view this content.

I always get an ERROR in this Line

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

could you please help me to solve this issue