copy blank cells

  • Thread starter Vicneswari Murugan
  • Start date
V

Vicneswari Murugan

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

Randy Lefferts

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
 
Top