Formulas

Hi Alison,

Thank you for your question.

Imagine you have a cell in Sheet 1 of your workbook which contained the value of 60. This figure then needs to be linked into Sheet 2 which is used in another formula.

Copy the cell containing 60, switch to Sheet 2 and click into a cell and then use the Edit - Paste Special - Paste Link command. So any changes to the cell in Sheet 1 will update the cell in Sheet 2.

Then in another cell on Sheet 2 you could create a formula which includes the linked cell.

I hope this answers your question.

Regards

Simon