Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a connection between cells on different worksheets
I am trying to create a connection or reference between cells on different
worksheets within the same workbook that will automatically propogate as data is changed within the ference cell. I am using Excel 2003. Hope this makes sense and someone can help. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a connection between cells on different worksheets
brada_awan,
You should be able to have this happen by having the first cell equal the second cell. Something like this: Select the cell in the first sheet that you want to reference by clicking in it. Hit the = sign and then go to the other cell that you want to have show in the first cell. If you are on Sheet 1, Cell B4 and wanted it to show Sheet 2, Cell B4, it should look something like this: =Sheet2!B4 Anytime you changed the data in Sheet 2, cell B4 the cell in Sheet 1 would change and show that data. "brada_awan" wrote: I am trying to create a connection or reference between cells on different worksheets within the same workbook that will automatically propogate as data is changed within the ference cell. I am using Excel 2003. Hope this makes sense and someone can help. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a connection between cells on different worksh
Thanks so much Fleone!
"Fleone" wrote: brada_awan, You should be able to have this happen by having the first cell equal the second cell. Something like this: Select the cell in the first sheet that you want to reference by clicking in it. Hit the = sign and then go to the other cell that you want to have show in the first cell. If you are on Sheet 1, Cell B4 and wanted it to show Sheet 2, Cell B4, it should look something like this: =Sheet2!B4 Anytime you changed the data in Sheet 2, cell B4 the cell in Sheet 1 would change and show that data. "brada_awan" wrote: I am trying to create a connection or reference between cells on different worksheets within the same workbook that will automatically propogate as data is changed within the ference cell. I am using Excel 2003. Hope this makes sense and someone can help. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
Copying Cells From Multiple Worksheets to Create Summary Sheet | Excel Discussion (Misc queries) | |||
How do I create a formula using cells from multiple worksheets? | Excel Worksheet Functions | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) |