Linking worksheets

[John]

Would somebody please advise how to link worksheets together.


Thanks in advance

John

 

[JMay]

please e-x-p-a-n-d on the use of "link"..(what do you mean?)

 

[John]

specifically cell referencing between sheets

please e-x-p-a-n-d on the use of "link"..(what do you mean?)

 

[Dave Peterson]

A simple example:

type = (equal sign) in A1 of sheet1.

go to a cell in another worksheet and click on it to complete the formula (and
hit enter).

Excel will help and you'll end up with something like:

=Sheet2!G17

If G17 is blank, you should see a 0. You can hide that by:

=if(sheet2!g17="","",sheet2!g17)

You can use the same technique between worksheets in different workbooks, too.
Watch what happens to the formula when you close the "sending" workbook.

 

[JE McGimpsey]

To link cell A1 in sheet1 with cell J10 in sheet2, enter this in sheet1:

A1: ='Sheet2'!J10

the single quotes are only necessary if the sheet has a space in the
name.

The easiest way to do this is to type an = sign in the cell you want to
contain the reference, then navigate to the sheet and cell to be
referenced and select it. Type Enter. XL will take care of the rest.

 

[David McRitchie]

Hi John,
= C4 + sheet2!D32
= C4 + 'sheet forty'!D32

You can type in =c4 +
then got to the other sheet and select the cell, then hit
enter to finish off the formula.

Hyperlinks are also references so for more examples on
the above or on hyperlinks see
http://www.mvps.org/dmcritchie/excel/sheets.htm

 

[Gord Dibben]

John

Three methods.

1. In sheet2 enter an = sign in a cell then switch to sheet1 and select a
cell and hit <ENTER> key.

2. In sheet2 enter =sheet1!A1

3. Copy a cell from sheet1 and switch to sheet2 and Paste Special>Paste Link

In all 3 cases, the cell value from sheet1 will be linked to sheet2. When
sheet1 cell value changes, so to shall sheet2 linked cell change.

Other things you can do with linked cells....

On sheet6 in a cell enter =SUM(sheet1:sheet5!A1) which will SUM all A1 cells
from sheet1 through sheet5

NOTE: if your sheet names have spaces you must surround the sheet references
with single quotes.

='Sheet one'!A1

Gord Dibben Excel MVP