Rachel has attended:
Excel Introduction course
Excel Intermediate course
Formulas
How do i link formulas in one sheet to other formulas in another sheet?
RE: Formulas
Hi Rachel
Thank you for your question.
There are two ways of linking cells between sheets.
1. Select a cell in the sheet you wish to create the link in; then type in = and select the cell in the other sheet you want to link to. Press Enter.
2. Select the cell you wish to create a link to and copy it. Go to the cell you wish to create the link in, then go to Edit - Paste Special and click the Paste Link button.
I hope this helps.
Amanda