Formulas

Hi Keith

Firstly go into your summary sheet and select the cell that you want your formula to appear. Type = and then click through to the sheet the formula appears in and then click on the cell. Finally hit the enter key and the cell in your summary sheet will update automatically with the info in that sheet.

Lets say I wanted the info contained in Sheet 2 cell A1 to be copied into Sheet 1 cell A1 as my summary sheet. My formula in Sheet 1 cell A1 would be : =Sheet2!A1

Hope that helps
David