Link Worksheet to other worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Wendy,
Copy the formula I gave you to as many cells as are needed
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Worksheet linking 2
Delete All Links to Worksheet 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Linking value of cell on one worksheet to a column on another work 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Linking a workbook to worksheets 1
Linking data from one worksheet to another... 2

Back
Top