software

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

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 quot;=quot; 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...
--
Kevin Backmannquot;Gazquot; wrote:

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

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
quot;Gazquot; wrote:

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