microsoft excel training - Formulas

Hi Fiona. Formulae can simply be cut and pasted between workbooks but remember that cell referencing is crucial here. For the formula to work it has to be in the same place or referencing the same cells on the new worksheet, otherwise you'll get a REF! error message. Considering building new formulae into the new workbook or saving another copy of the source workbook and customising that.