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

 

[My Aswer Is This]

I always like to help but sometimes it hard to understand what users want.
Here is an example:

You said:
"I have two Sheets "Summary" and "Worksheet"
OK you have a sheet named "Summary"
And do you really have a Worksheet named "Worksheet"

I would think you would name your sheets like "Alpha" & "Bravo"

And I surely do not know what this means:
* 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

Does this mean The Range C10 on sheet named "Summary" is linked to sheet named "Worksheet" Range "J3"

Is that what that means?
And on and on.
I would never name my worksheet "Worksheet"
And why use >C10
In Excel this would mean greater then C10

 

[My Aswer Is This]

If you want to results of the Range "D12" of Sheet name "Alpha" in another sheet put this in the cell where you want the results.

=Alpha!D12

And this does not require Vba

 

[stephkc24]

I always like to help but sometimes it hard to understand what users want.
Here is an example:

You said:
"I have two Sheets "Summary" and "Worksheet"
OK you have a sheet named "Summary"
And do you really have a Worksheet named "Worksheet"

I would think you would name your sheets like "Alpha" & "Bravo"

And I surely do not know what this means:
* 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

Does this mean The Range C10 on sheet named "Summary" is linked to sheet named "Worksheet" Range "J3"

Is that what that means?
And on and on.
I would never name my worksheet "Worksheet"
And why use >C10
In Excel this would mean greater then C10

Hi

Sorry for the confusion does this help?

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

I have cell Summary.C10 that i would like to link to Data.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 Data.J3
* Summary.C11 that i would like to link to Data.K3
* Summary.C12 that i would like to link to Data.L3
* Summary.C13 that i would like to link to Data.u3
* Summary.C14 that i would like to link to Data.V3

Quote Reply
Report

 

[stephkc24]

If you want to results of the Range "D12" of Sheet name "Alpha" in another sheet put this in the cell where you want the results.

=Alpha!D12

And this does not require Vba

Simply doing this will copy the current data from one location to another. but will not allow you to update it from that location. I need a way to have two cells in two different sheets that are linked. so if you change either cell it will update the corresponding one regardless of which sheet you are on

 

[My Aswer Is This]

Hi

Sorry for the confusion does this help?

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

I have cell Summary.C10 that i would like to link to Data.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 Data.J3
* Summary.C11 that i would like to link to Data.K3
* Summary.C12 that i would like to link to Data.L3
* Summary.C13 that i would like to link to Data.u3
* Summary.C14 that i would like to link to Data.V3

Quote Reply
Report

In Post 3 I showed you how to do this

 

[My Aswer Is This]

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.

 

[stephkc24]

In Post 3 I showed you how to do this

All this does is copy the data from Alpha!D12 to the cell of the corresponding sheet that you copy this formula to.

Then what happens when i go to that cell that you copied this formula in and i change the value? how does that reflect back into Alpha.D12?

 

[My Aswer Is This]

All this does is copy the data from Alpha!D12 to the cell of the corresponding sheet that you copy this formula to.

Then what happens when i go to that cell that you copied this formula in and i change the value? how does that reflect back into Alpha.D12?

I suggest you try what I suggested if you change the Value in Alpha it changes the value in the sheet you put the =Alpha!D12

 

[stephkc24]

I suggest you try what I suggested if you change the Value in Alpha it changes the value in the sheet you put the =Alpha!D12

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