Linking Two Tables

[Aviral]

I have two tables - Source_Table and Destination_Table in the same sheet having the same number of rows and columns.
I want to link the two such that any changes made in Source_Table should reflect in Destination_Table as well.
This should include inserting or deleting a row.
P.S. - I want to do this without using macros

 

[mrhstn]

While in your source table goto Data >> From Table/Range, don't make any changes in the power query dialogue then just select Close & Load To (really important don't choose the default Close & Load but Load To from the dropdown). Choose to put it in an existing sheet, select the cell you want to put it in, this is your destination table.

Now you can change the source table to your hearts content and occasionally click refresh to update the destination table, without a macro.