| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
| How do I copy a worksheet without the link to the original workboo | Excel Discussion (Misc queries) | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| Changing Worksheet Name in Link | Excel Worksheet Functions | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Linear Mode
