In Sheet3,
In B27: =IF(Sheet1!C6="","",Sheet1!C6)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"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