Hi, when you have multiple sheets in an Excel document, is it possible
to have a cell in one sheet correspond to a cell in other?

for example if i had a sheet labled "Sales", and a cell in it that
described the average weekly sales based on information within that
sheet, would I be able to use what is in the "average weekly sales"
cell in another spreadsheet?

sorry if that's hard to follow.


--
simserob
------------------------------------------------------------------------
simserob's Profile: http://www.excelforum.com/member.php...o&userid=36635
View this thread: http://www.excelforum.com/showthread...hreadid=573442

If I follow you, yes. Go to the second sheet. Go to the cell where you
want to put the data from the first sheet. Type "=" without the quotes.
Don't hit Enter. Go to the first sheet. Click on the cell you want. Hit
Enter. You now have a formula in the second sheet that will always display
the value of the cell you chose in the first sheet. HTH Otto
"simserob" wrote in
message ...

Hi, when you have multiple sheets in an Excel document, is it possible
to have a cell in one sheet correspond to a cell in other?

for example if i had a sheet labled "Sales", and a cell in it that
described the average weekly sales based on information within that
sheet, would I be able to use what is in the "average weekly sales"
cell in another spreadsheet?

sorry if that's hard to follow.


--
simserob
------------------------------------------------------------------------
simserob's Profile:
http://www.excelforum.com/member.php...o&userid=36635
View this thread: http://www.excelforum.com/showthread...hreadid=573442