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

Thanks a lot

 

[S. Das]

Here is your sample file. I think this will meet ur need. And I don't know is there any way of inserting row without macro.

 

[Aviral]

No. It doesn't meet my need.
I want the two tables as I had added in the Sample file and not side by side.

 

[Chief Ace]

I'm not really sure if this is what you are looking for. If you add another entry in source sheet it will automatically added in the destination sheet. if you delete a row in the source sheet it will delete the row in destination sheet. Hope this help.

 

[Aviral]

Hi Chief Ace.
Thanks a lot. But I know this method.
I want something similar but in the same sheet. I need to have both the tables in the same worksheet.
Or if possible, one sheet containing one master table and two children tables in a different worksheet.

 

[Chief Ace]

You said you wanted it on the same sheet. The question is:

How big is your data? # of columns/rows?
and can you clarify on this "Or if possible, one sheet containing one master table and two children tables in a different worksheet."