Linking Sheets

S

simserob

Hi, when you have multiple sheets in an Excel document, is it possibl
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 tha
described the average weekly sales based on information within tha
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
 
O

Otto Moehrbach

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
 
Top