"Eileen" wrote:
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.

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.