how you make links between diff. cells on diff. work sheets

[NYC-MIKE]

i'm trying to do 3 or 4 work sheets on the same work book, but i have some
common cells on all work sheets so i want to have the same cell for example
on all work sheets related when this cell changes on one sheet it changes
itself on the other sheets as well?

 

[Gav123]

Hi,

Say that you want the cel B2 on sheet2, sheet3 and sheet4 to equal Cell B2
on sheet 1...

Click on sheet 2 tab and hold down the shift key and click on sheet 4 tab
(this selects sheets 2-4)

Release shift key

Click on cell B2 in sheet2 and type =

Click on sheet 1 and cell B2

Then press enter

Now when you type anything in cell B2 on sheet 1 the other sheets will change.

Hope this helps,

Gav.

Please mark this reply if the post was helpfull to let other users know

 

[NYC-MIKE]

Thanks Gav123,
you were really helpfull,
Mike

Hi,

Say that you want the cel B2 on sheet2, sheet3 and sheet4 to equal Cell B2
on sheet 1...

Click on sheet 2 tab and hold down the shift key and click on sheet 4 tab
(this selects sheets 2-4)

Release shift key

Click on cell B2 in sheet2 and type =

Click on sheet 1 and cell B2

Then press enter

Now when you type anything in cell B2 on sheet 1 the other sheets will change.

Hope this helps,

Gav.

Please mark this reply if the post was helpfull to let other users know

 

[Pete_UK]

You must un-group the sheets when you have finished the procedure
outlined by Gav - either right-click on a sheet tab then click on Un-
group sheets, or simply click on another sheet tab (eg Sheet1).

Hope this helps.

Pete