copying "blank" cells

[Silvabod]

on sheet1, a range 60 x 7 cells, all condtionally formatted but not all used
(i.e. data content may be blank).

Want the exact range onto sheet 2 (i.e. A1: G70 on sheet2
("=sheet1!A1:G70)") which works to a degree - have got the conditional
format OK on all cells.
All the "filled" data cells copy over correctly, but the "blank" data
content becomes "0" (I need it blank)

How to make blank cells on sheet 2 = blank cells on Sheet 1, still
conditionally formatted
(conditional format is text/font display if a numeric condition is met) ?

 

[MartinW]

Hi Silvabod,

Perhaps - Tools>Options>View tab and uncheck "zero values"

 

[Pete_UK]

You could change your formulae from:

=sheet1!A1

to:

=IF(sheet1!A1="","",sheet1!A1)

then copy across and down.

Hope this helps.

Pete

 

[Silvabod]

Martin, Pete - thanks! Am tied up with something else, but will try ASAP -
I'm sure you're both right! (Excel seems to have multiple solutions).

 

[Silvabod]

Martin, tried this first - exactly right, and quick!
(just one tick removal in "view" did it all).