How do I create a connection between cells on different worksheets

[brada_awan]

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!

 

[Fleone]

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]

Thanks so much Fleone!

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.