copy blank cells
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? |
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? . |
All times are GMT +1. The time now is 11:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com