Have already solved the problem, many thanks Max,

Dave

"Dave in Ampthill" wrote:

I have 3 sheets in a spreadsheet and wish the data in cell B27 on sheet 3 to
equal the data in cell C6 on sheet 1, i.e. if C6 = 3200 then B27 will be the
same. How do I write this as a formula or instruction?

Many thanks for your help,

Dave