merging spreadsheet data
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 |
merging spreadsheet data
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 |
All times are GMT +1. The time now is 04:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com