Link Worksheet to other worksheets
 

What I am trying to do is link a worksheet to another worksheet. When I
change the original I want it to change on all of the other sheets. Is this
possible?

Type some value in A1 of Sheet1
Open Sheet2 and in any cell type =Sheet1!A1
Now change A1 on SHeet1 and check the result in Sheet2

If you want to link to a sheet in another workbook it is easier to type =
and then click on the target cell in the other workbook.

best wishes


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Wendy Gunter" <Wendy wrote in message
...
What I am trying to do is link a worksheet to another worksheet. When I
change the original I want it to change on all of the other sheets. Is
this
possible?

I need to link the whole worksheet not just a cell. I'm sure now that this
can be done, just don't know how.
thank you Bernard.

"Bernard Liengme" wrote:

Type some value in A1 of Sheet1
Open Sheet2 and in any cell type =Sheet1!A1
Now change A1 on SHeet1 and check the result in Sheet2

If you want to link to a sheet in another workbook it is easier to type =
and then click on the target cell in the other workbook.

best wishes


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Wendy Gunter" <Wendy wrote in message
...
What I am trying to do is link a worksheet to another worksheet. When I
change the original I want it to change on all of the other sheets. Is
this
possible?

Wendy,
Copy the formula I gave you to as many cells as are needed
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Wendy Gunter" wrote in message
...
I need to link the whole worksheet not just a cell. I'm sure now that this
can be done, just don't know how.
thank you Bernard.

"Bernard Liengme" wrote:

Type some value in A1 of Sheet1
Open Sheet2 and in any cell type =Sheet1!A1
Now change A1 on SHeet1 and check the result in Sheet2

If you want to link to a sheet in another workbook it is easier to type =
and then click on the target cell in the other workbook.

best wishes


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Wendy Gunter" <Wendy wrote in message
...
What I am trying to do is link a worksheet to another worksheet. When I
change the original I want it to change on all of the other sheets. Is
this
possible?