You're welcome, Colin.

Pete

On Jan 1, 11:11*pm, Colin Hayes wrote:
Hi Pete

Yes , I understand the principal of course. The problem is in the
process rather than the outcome , however.

I'm pasting new figures into both sheets so the comparison can be made.
As soon as I paste into the first sheet , the calculating starts. This
will give false results of course , because I have yet to paste into the
second sheet. It's comparing old data. I can't open the second sheet
because the machine is preoccupied with calculating on the first sheet.

Once this has finished , I can open the second sheet and paste in the
figures. When the calculation has finished , I can go back to the first
sheet , and the calculating starts again...

I've got around this by switching auto-calculation off via the Options
menu , and then pasting my data in peace. Then I switch auto-calculation
back on , and it does it's job. Seems a bit long-winded , that's all.

Anyway , job done Pete , and I'm very grateful for you help and
expertise.

Best Wishes

Colin