Linking cells

G

Gaz

Im trying to link the cells within my workbook so that if I enter a value
into a "master" sheet then, if I need it to, the same value will
automatically enter in cells on several other sheets. Can anyone help?
 
K

Kevin B

Here is an example of a formula that is in a sheet other than Sheet1, and it
returns the value in Sheet1 cell A1:

=Sheet1!A1

You can enter the formula by going to the worksheet where you want the value
to appear when changes are made in the master worksheet. Type an "=" to
start the formula and then press either Ctrl+PgDn or Ctrl+PgUp until you get
to the master sheet and click on the cell you wish to reference.

Hope this helps...
 
M

Michael Glenn

You can refer to a cell in another sheet using the syntax:
SheetName!CellReference

So if you want to refer to cell A1 on a sheet named Master, use : =Master!A1
 
Top