I have an excel workbook with multiple worksheets. How do I create a
cell on each of the pages such that if I change it on any one sheet, I
will get that value in the cell I want on each individual worksheet?

If that's not clear, let's say on sheet 1 I want A1 to be tied to A2
on sheet 2. If I change sheet1 A1 I want sheet2 A2 to change to the
same value. Likewise if I change A2 on sheet 2 I want sheet1 A1 to
take the same value.

That is a circular reference. In this case it cannot be resolved. If you
change A1 on sheet1, A2 on sheet2 changes to it (a1 on sheet1) and sheet1,
A1 then changes to sheet2, A2 which then changes to sheet1, A1 which then
changes to sheet2,.A2 which then changes to sheet1, A1 which then changes to
sheet2, A2, .......etc, Get the idea? Round and round we go. Where does it
stop?

"Ross Mau" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have an excel workbook with multiple worksheets. How do I create a
> cell on each of the pages such that if I change it on any one sheet, I
> will get that value in the cell I want on each individual worksheet?
>
> If that's not clear, let's say on sheet 1 I want A1 to be tied to A2
> on sheet 2. If I change sheet1 A1 I want sheet2 A2 to change to the
> same value. Likewise if I change A2 on sheet 2 I want sheet1 A1 to
> take the same value.
>

Ross,

Two possibilities. First, put the value in one cell only, like Sheet1 A1, and have the
others linked to it. In other cells, you would have:
='Sheet1'!A1
You would change only Sheet1 A1. The links (formulas) must remain in the other cells.

If you need to be able to change any of the cells, and have the others follow, then you need
to have event macros that fire when a sheet is changed, examine which cell was changed, and
if it's one of those we care about, write that value into all the other cells.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Ross Mau" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have an excel workbook with multiple worksheets. How do I create a
> cell on each of the pages such that if I change it on any one sheet, I
> will get that value in the cell I want on each individual worksheet?
>
> If that's not clear, let's say on sheet 1 I want A1 to be tied to A2
> on sheet 2. If I change sheet1 A1 I want sheet2 A2 to change to the
> same value. Likewise if I change A2 on sheet 2 I want sheet1 A1 to
> take the same value.
>

I think the point is moot. It is a circular reference.

"Earl Kiosterud" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Ross,
>
> Two possibilities. First, put the value in one cell only, like Sheet1 A1,
> and have the others linked to it. In other cells, you would have:
> ='Sheet1'!A1
> You would change only Sheet1 A1. The links (formulas) must remain in the
> other cells.
>
> If you need to be able to change any of the cells, and have the others
> follow, then you need to have event macros that fire when a sheet is
> changed, examine which cell was changed, and if it's one of those we care
> about, write that value into all the other cells.
> --
> Regards from Virginia Beach,
>
> Earl Kiosterud
> www.smokeylake.com
>
> Note: Top-posting has been the norm here.
> Some folks prefer bottom-posting.
> But if you bottom-post to a reply that's
> already top-posted, the thread gets messy.
> When in Rome...
> -----------------------------------------------------------------------
> "Ross Mau" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>I have an excel workbook with multiple worksheets. How do I create a
>> cell on each of the pages such that if I change it on any one sheet, I
>> will get that value in the cell I want on each individual worksheet?
>>
>> If that's not clear, let's say on sheet 1 I want A1 to be tied to A2
>> on sheet 2. If I change sheet1 A1 I want sheet2 A2 to change to the
>> same value. Likewise if I change A2 on sheet 2 I want sheet1 A1 to
>> take the same value.
>>
>
>

No it's not moot nor is it a circular reference


--

Regards,

Peo Sjoblom





"Wondering" <(E-Mail Removed)> wrote in message
news:FK_Ki.52604$(E-Mail Removed)...
>I think the point is moot. It is a circular reference.
>
> "Earl Kiosterud" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Ross,
>>
>> Two possibilities. First, put the value in one cell only, like Sheet1
>> A1, and have the others linked to it. In other cells, you would have:
>> ='Sheet1'!A1
>> You would change only Sheet1 A1. The links (formulas) must remain in the
>> other cells.
>>
>> If you need to be able to change any of the cells, and have the others
>> follow, then you need to have event macros that fire when a sheet is
>> changed, examine which cell was changed, and if it's one of those we care
>> about, write that value into all the other cells.
>> --
>> Regards from Virginia Beach,
>>
>> Earl Kiosterud
>> www.smokeylake.com
>>
>> Note: Top-posting has been the norm here.
>> Some folks prefer bottom-posting.
>> But if you bottom-post to a reply that's
>> already top-posted, the thread gets messy.
>> When in Rome...
>> -----------------------------------------------------------------------
>> "Ross Mau" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>>I have an excel workbook with multiple worksheets. How do I create a
>>> cell on each of the pages such that if I change it on any one sheet, I
>>> will get that value in the cell I want on each individual worksheet?
>>>
>>> If that's not clear, let's say on sheet 1 I want A1 to be tied to A2
>>> on sheet 2. If I change sheet1 A1 I want sheet2 A2 to change to the
>>> same value. Likewise if I change A2 on sheet 2 I want sheet1 A1 to
>>> take the same value.
>>>
>>
>>
>
>

I apologize Wondering, it was sloppy reading on my part, of course it is
circular reference if one uses formulas


--

Regards,

Peo Sjoblom





"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> No it's not moot nor is it a circular reference
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
>
>
>
> "Wondering" <(E-Mail Removed)> wrote in message
> news:FK_Ki.52604$(E-Mail Removed)...
>>I think the point is moot. It is a circular reference.
>>
>> "Earl Kiosterud" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Ross,
>>>
>>> Two possibilities. First, put the value in one cell only, like Sheet1
>>> A1, and have the others linked to it. In other cells, you would have:
>>> ='Sheet1'!A1
>>> You would change only Sheet1 A1. The links (formulas) must remain in
>>> the other cells.
>>>
>>> If you need to be able to change any of the cells, and have the others
>>> follow, then you need to have event macros that fire when a sheet is
>>> changed, examine which cell was changed, and if it's one of those we
>>> care about, write that value into all the other cells.
>>> --
>>> Regards from Virginia Beach,
>>>
>>> Earl Kiosterud
>>> www.smokeylake.com
>>>
>>> Note: Top-posting has been the norm here.
>>> Some folks prefer bottom-posting.
>>> But if you bottom-post to a reply that's
>>> already top-posted, the thread gets messy.
>>> When in Rome...
>>> -----------------------------------------------------------------------
>>> "Ross Mau" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>>I have an excel workbook with multiple worksheets. How do I create a
>>>> cell on each of the pages such that if I change it on any one sheet, I
>>>> will get that value in the cell I want on each individual worksheet?
>>>>
>>>> If that's not clear, let's say on sheet 1 I want A1 to be tied to A2
>>>> on sheet 2. If I change sheet1 A1 I want sheet2 A2 to change to the
>>>> same value. Likewise if I change A2 on sheet 2 I want sheet1 A1 to
>>>> take the same value.
>>>>
>>>
>>>
>>
>>
>
>

Hi guys,

I'm not sure why this circular reference issue has come under my post. My formula
suggestion is to have all the other cells all refer to one cell, then change the data only
in that one cell. There's no circular reference there.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>I apologize Wondering, it was sloppy reading on my part, of course it is circular reference
>if one uses formulas
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
>
>
>
> "Peo Sjoblom" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> No it's not moot nor is it a circular reference
>>
>>
>> --
>>
>> Regards,
>>
>> Peo Sjoblom
>>
>>
>>
>>
>>
>> "Wondering" <(E-Mail Removed)> wrote in message
>> news:FK_Ki.52604$(E-Mail Removed)...
>>>I think the point is moot. It is a circular reference.
>>>
>>> "Earl Kiosterud" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> Ross,
>>>>
>>>> Two possibilities. First, put the value in one cell only, like Sheet1 A1, and have the
>>>> others linked to it. In other cells, you would have:
>>>> ='Sheet1'!A1
>>>> You would change only Sheet1 A1. The links (formulas) must remain in the other cells.
>>>>
>>>> If you need to be able to change any of the cells, and have the others follow, then you
>>>> need to have event macros that fire when a sheet is changed, examine which cell was
>>>> changed, and if it's one of those we care about, write that value into all the other
>>>> cells.
>>>> --
>>>> Regards from Virginia Beach,
>>>>
>>>> Earl Kiosterud
>>>> www.smokeylake.com
>>>>
>>>> Note: Top-posting has been the norm here.
>>>> Some folks prefer bottom-posting.
>>>> But if you bottom-post to a reply that's
>>>> already top-posted, the thread gets messy.
>>>> When in Rome...
>>>> -----------------------------------------------------------------------
>>>> "Ross Mau" <(E-Mail Removed)> wrote in message
>>>> news:(E-Mail Removed)...
>>>>>I have an excel workbook with multiple worksheets. How do I create a
>>>>> cell on each of the pages such that if I change it on any one sheet, I
>>>>> will get that value in the cell I want on each individual worksheet?
>>>>>
>>>>> If that's not clear, let's say on sheet 1 I want A1 to be tied to A2
>>>>> on sheet 2. If I change sheet1 A1 I want sheet2 A2 to change to the
>>>>> same value. Likewise if I change A2 on sheet 2 I want sheet1 A1 to
>>>>> take the same value.
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Sorry about that Earl, I responded to a post that was responding to you but
I then read the OP's first post thus I retracted it . It is definitely clear
that your solution is not a circular reference so my first post should have
stood


--


Regards,


Peo Sjoblom



"Earl Kiosterud" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi guys,
>
> I'm not sure why this circular reference issue has come under my post. My
> formula suggestion is to have all the other cells all refer to one cell,
> then change the data only in that one cell. There's no circular reference
> there.
> --
> Regards from Virginia Beach,
>
> Earl Kiosterud
> www.smokeylake.com
>
> Note: Top-posting has been the norm here.
> Some folks prefer bottom-posting.
> But if you bottom-post to a reply that's
> already top-posted, the thread gets messy.
> When in Rome...
> -----------------------------------------------------------------------
> "Peo Sjoblom" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>>I apologize Wondering, it was sloppy reading on my part, of course it is
>>circular reference if one uses formulas
>>
>>
>> --
>>
>> Regards,
>>
>> Peo Sjoblom
>>
>>
>>
>>
>>
>> "Peo Sjoblom" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> No it's not moot nor is it a circular reference
>>>
>>>
>>> --
>>>
>>> Regards,
>>>
>>> Peo Sjoblom
>>>
>>>
>>>
>>>
>>>
>>> "Wondering" <(E-Mail Removed)> wrote in message
>>> news:FK_Ki.52604$(E-Mail Removed)...
>>>>I think the point is moot. It is a circular reference.
>>>>
>>>> "Earl Kiosterud" <(E-Mail Removed)> wrote in message
>>>> news:(E-Mail Removed)...
>>>>> Ross,
>>>>>
>>>>> Two possibilities. First, put the value in one cell only, like Sheet1
>>>>> A1, and have the others linked to it. In other cells, you would have:
>>>>> ='Sheet1'!A1
>>>>> You would change only Sheet1 A1. The links (formulas) must remain in
>>>>> the other cells.
>>>>>
>>>>> If you need to be able to change any of the cells, and have the others
>>>>> follow, then you need to have event macros that fire when a sheet is
>>>>> changed, examine which cell was changed, and if it's one of those we
>>>>> care about, write that value into all the other cells.
>>>>> --
>>>>> Regards from Virginia Beach,
>>>>>
>>>>> Earl Kiosterud
>>>>> www.smokeylake.com
>>>>>
>>>>> Note: Top-posting has been the norm here.
>>>>> Some folks prefer bottom-posting.
>>>>> But if you bottom-post to a reply that's
>>>>> already top-posted, the thread gets messy.
>>>>> When in Rome...
>>>>> -----------------------------------------------------------------------
>>>>> "Ross Mau" <(E-Mail Removed)> wrote in message
>>>>> news:(E-Mail Removed)...
>>>>>>I have an excel workbook with multiple worksheets. How do I create a
>>>>>> cell on each of the pages such that if I change it on any one sheet,
>>>>>> I
>>>>>> will get that value in the cell I want on each individual worksheet?
>>>>>>
>>>>>> If that's not clear, let's say on sheet 1 I want A1 to be tied to A2
>>>>>> on sheet 2. If I change sheet1 A1 I want sheet2 A2 to change to the
>>>>>> same value. Likewise if I change A2 on sheet 2 I want sheet1 A1 to
>>>>>> take the same value.
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>