G Guest Jul 7, 2004 #1 I would like to make a cell on sheet 2 equal the contents of a cell in sheet 1 without blank cells in sheet 1 showing up as zeros in sheet 2.
I would like to make a cell on sheet 2 equal the contents of a cell in sheet 1 without blank cells in sheet 1 showing up as zeros in sheet 2.
J Jay Jul 7, 2004 #2 I would like to make a cell on sheet 2 equal the contents of a cell in sheet 1 without blank cells in sheet 1 showing up as zeros in sheet 2. Click to expand... In Sheet2 cell A1, put =IF(Sheet1!A1="","",Sheet1!A1) Then extend to the right for as many columns as you need. Then extend that row down for as many rows as you need.
I would like to make a cell on sheet 2 equal the contents of a cell in sheet 1 without blank cells in sheet 1 showing up as zeros in sheet 2. Click to expand... In Sheet2 cell A1, put =IF(Sheet1!A1="","",Sheet1!A1) Then extend to the right for as many columns as you need. Then extend that row down for as many rows as you need.
