copying data from a cell in sheet 1 to same c

Microsoft Office excel 2007 home & stude...
July 14, 2010 at 18:50:01
Specs: Windows Vista
I would like to copy data from a cell in sheet 1 to a cell in sheet 2. I know how to do this, however, if the cell in sheet 1 is empty, then the cell in sheet 2 will have a 0 in it. I want to find out if I can get rid of the 0 in sheet 2 or just have it left blank.

Am making a workbook with an invoice for sheet 1 and a shipper for sheet 2. I want to be able copy what I put in for bill to:, ship to, etc from sheet 1 to sheet 2 as well as products ordered. However sometimes there will be blanks on sheet 1 but the formula is still there in sheet 2 and returns a 0. Do not want a 0 if it should be blank. Can you help?


See More: copying data from a cell in sheet 1 to same c

Report •


#1
July 15, 2010 at 06:17:06
Hi,

Use this formula:
=IF(Sheet2!B1="","",Sheet2!B1)

The IF statement tests if the cell on the other sheet is empty.
If it is empty (IF condition is true) it returns ""
If it is not empty (IF condition is false) it returns the value in the cell on the other sheet.

Regards


Report •

#2
July 15, 2010 at 09:53:37
Thank you so much that did indeed do what I wanted it to do.

Report •
Related Solutions


Ask Question