Try using =IF(Sheet1!A1="","",Sheet1!A1) for cell A1 on
the 2nd sheet. Copy for the rest of the cells that you
need to. HTH
-----Original Message-----
How can I enter the same data as I type into sheet 1 to
be appeared the same
in sheet 2?
Example :
When I type <1<2<blank cell<3<0<-<A in sheet 1, I
want the same to be
appeared in sheet 2. If I use 'equals(=)' to refer to
the cells, the blank
cell turns into 0 value. I want the blank cell in sheet
1 appear also as a
blank cell in sheet 2. How can I do this?
.