Linking Sheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

simserob - 19 Aug 2006 20:45 GMT

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

Reply to this Message

Otto Moehrbach - 19 Aug 2006 22:26 GMT

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

> 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?
[quoted text clipped - 5 lines]
>
> sorry if that's hard to follow.

Reply to this Message