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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NYC-MIKE - 11 Feb 2008 14:41 GMT

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?

Reply to this Message

Gav123 - 11 Feb 2008 15:43 GMT

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

> 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?

Reply to this Message

NYC-MIKE - 11 Feb 2008 17:03 GMT

Thanks Gav123,
you were really helpfull,
Mike

> Hi,
>
[quoted text clipped - 24 lines]
> > on all work sheets related when this cell changes on one sheet it changes
> > itself on the other sheets as well?

Reply to this Message

Pete_UK - 11 Feb 2008 17:05 GMT

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

> Hi,
>
[quoted text clipped - 26 lines]
>
> - Show quoted text -

Reply to this Message