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