ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   copy blank cells (https://www.excelbanter.com/excel-discussion-misc-queries/904-copy-blank-cells.html)

Vicneswari Murugan

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?


All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com