sync same cell value in multiple places

[Bruce]

I was wondering if anybody has done this...

I want to be able to define a cell name and use it in multiple place.
However, when I update any of those cells with the same name, it will
update all of them.
As an example, I would like to have a cell called DISTANCE in Sheet 1,
2 and 3 for further computation.
If I change the value of DISTANCE in Sheet 1, the DISTANCE value in
Sheet 2 and 3 will get updated too.

Thanks in advance,
Bruce

 

[Dave Peterson]

Excel doesn't really work well when you try to update one cell and push that
value to a bunch of other cells.

But it works very well when you update a single cell and pull that value into as
many cells as you want using a formula like:

='Sheet1'!A1
or
=if('sheet1'!a1="","",'sheet1'!a1)
To make sure that you don't see a 0 when A1 on sheet1 is empty.

 

[Hans Terkelsen]

I was wondering if anybody has done this...

I want to be able to define a cell name and use it in multiple place.
However, when I update any of those cells with the same name, it will
update all of them.
As an example, I would like to have a cell called DISTANCE in Sheet 1,
2 and 3 for further computation.
If I change the value of DISTANCE in Sheet 1, the DISTANCE value in
Sheet 2 and 3 will get updated too.

Thanks in advance,
Bruce

Hi Bruce.

Perhaps you are searching for a way to have the name DISTANCE
take independent values in different sheets.

A normal global name is visible from all sheets.
But Excel has the option of sheet-local names.

Go to Sheet1, and delete the global name DISTANCE first
When a new name is written like Sheet1!DISTANCE in the name box,
then it will be local to Sheet1, under the name DISTANCE,
It can not be seen from Sheet2.
Go to Define Names in Sheet1 to see the difference.

Sheet2 must have its own local name Sheet2!DISTANCE defined correspondingly

Hans T.