Referencing between worksheets

Hi Alasdair,

Thank you for your post, in order to do this I would probably use the Watch Window;

1. Go to the Ribbon and select the Formulas tab.

2. In the Formula Auditing section, select Watch Window.

3. The Watch Window will appear.

4. Click the Add Watch button to specify the cell you wish to monitor.

You can now monitor the value of the selected cell while continuing to work on any area of the workbook. You can also double-click on the cell in the Watch Window to quickly go to that cell.
I Hope that helps, regards Pete