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?