Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tab Formula from diff sheets | Excel Worksheet Functions | |||
Data from diff sheets to one common sheet | Excel Worksheet Functions | |||
average data from diff sheets | Excel Worksheet Functions | |||
how to add many cells on diff. sheets and put in 1 cell in excel | Excel Worksheet Functions | |||
Dragging formula linked to diff sheets | Excel Discussion (Misc queries) |