Multiple spreadsheets

Hi Robert,

Thank you for your question.

Open the two spreadsheets up and start a formula with an equals sign. Switch to the first workbook and select the cell you need to use. Choose the appropriate Operator( - + * etc.) and select another cell in the second workbook. Any changes made to the first workbook will update the formulas in the second workbook.

Alternatively, if there is a formula in a cell in workbook one that you want linked to a cell in workbook 2 then start with an equals sign in workbook 1. The next step is to switch to workbook two and select the cell with the formula in and press enter. This means the two workbooks are linked.

I hope this answers your question.

Regards

Simon