Two way linking of cells in multiple spreadsheets in same workbook using VBA

[Azuak]

Does anyone know how to do a Two way linking of cells in multiple spreadsheets in same workbook using VBA. i ve attached a sample file i ve been working on.

[tehneXus]

And on which sheet the links should be, where should they link?

[Azuak]

The first sheet is the summary. Other sheets like TFC,ACA,SPA etc will have detail data. The idea here is to link cells say in sheet name tfc to the appropriate column and row in the first sheet. And any changes made say in sheet named tfc will be reflected in the first sheet and vice versa. Sorry for not posting details. Hope someone will have a solution.

[Azuak]

sorry friends, the previous file had some unwanted sheets. here is the updated file. the problem remains the same.

[Azuak]

I am clueless when it comes to vba. help will be greatly appreciated.

[Azuak]

experts pls help!

[tehneXus]

My advice to you: restructure your workbook:

1. Keep all raw data on one sheet !
2. Use PivotTables -> automatic totals !

read this: http://www.ozgrid.com/Excel/ExcelSpr...ign.htm#Layout

Regards

[Azuak]

I came across a solution for two linking of cells in 2 sheets. Can someone modify the code to link more than 2 sheets

[Azuak]

Thanks tehneXus for prompt reply.

[Azuak]

Thanks tehneXus for prompt reply.