How do you Link Cells Between Sheets in same work book to change each cell value if either is changed?

[stephkc24]

Hi,

I'm new to VBA and was wondering if someone could help me out with the below?

I have two Sheets "Summary" and "Worksheet", both in the same workbook

I have cell Summary->C10 that i would like to link to Worksheet->J3 so that either cell can be modified and the other is updated.

I want to apply the above to all these cells as well:
* Summary->C10 that i would like to link to Worksheet->J3
* Summary->C11 that i would like to link to Worksheet->K3
* Summary->C12 that i would like to link to Worksheet->L3
* Summary->C13 that i would like to link to Worksheet->u3
* Summary->C14 that i would like to link to Worksheet->V3

Any help on how to accomplish this would be greatly appreciated

 

[daveG777]

If I've understood you, your request violates basic logic.

You can have in cell a1, the following formula: =b1. So, if you enter the value of 100 into b1, a1 will change to 100.

You can, instead, have in cell b11, the following formula: =a1. So, if you enter the value of 100 into a1, b1 will change to 100.

• However, you can't have it both ways. It would be like two mirrors reflecting each other to infinity.
• Also, to change the value where there is now a formula, you would have to delete the formula.

Please let me know if I've misunderstood your intention. Thank you.

 

[orthoimplantsgu]

But if you make a change in D12, the value in B1 of Beta sheet will not update automatically To do this, you need to select the cell B1 in Beta sheet and press F9. This will update the formula and show the new value in cell B1.

If you have a 2 sheet name Alpha and Beta

And you copy this formula "=Alpha!D12" into cell B1 in Beta sheet. Yes it will copy the value of the D12 cell from the Alpha sheet.

But what I'm looking for is the ability to be able to change the number in either cells D12 from Alpha sheet and D12 from Beta sheet. And the number be updated in either cell/sheets