|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?