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

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?

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

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" wrote:

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?

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

Thanks Gav123,
you were really helpfull,
Mike

"Gav123" wrote:

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" wrote:

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?

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

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

On Feb 11, 3:43*pm, Gav123 wrote:
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" wrote:
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?- Hide quoted text -

- Show quoted text -