| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Skip blank cells in diagrams | Charts and Charting in Excel | |||
| copy blank cells | Excel Discussion (Misc queries) | |||
| Averaging only cells with data | Excel Discussion (Misc queries) | |||
| how can I duplicate or copy a workbook then divide selected cells. | Excel Discussion (Misc queries) | |||
| Cells losing formatting | Excel Discussion (Misc queries) | |||
Linear Mode
