E Eileen Mar 13, 2010 #1 All i want to do is fill a cell with a number and that number to go into a cell on another sheet as well.
All i want to do is fill a cell with a number and that number to go into a cell on another sheet as well.
J Joe User Mar 13, 2010 #2 Eileen said: All i want to do is fill a cell with a number and that number to go into a cell on another sheet as well. Click to expand... A little light on details, dontcha think? Suppose the cell to be filled in is in A1 in Sheet1. Suppose the other cell is in B1 in Sheet2. Then B1 in Sheet2 should have the following formula: =if(Sheet1!A1="", "", Sheet1!A1) The first part of the IF statement ensures that if A1 appears to be blank, so will B1.
Eileen said: All i want to do is fill a cell with a number and that number to go into a cell on another sheet as well. Click to expand... A little light on details, dontcha think? Suppose the cell to be filled in is in A1 in Sheet1. Suppose the other cell is in B1 in Sheet2. Then B1 in Sheet2 should have the following formula: =if(Sheet1!A1="", "", Sheet1!A1) The first part of the IF statement ensures that if A1 appears to be blank, so will B1.
