copying data to different Cells

A

Auz

i wantto copy data from a front work sheet to different work sheets i am
using the copy function then paste options link cells. this iscopyingthe data
across fine but empty cells are being filled with a 0 or default date, how do
i ensure that these fields stay blank as in the original sheet
 
D

Dave Peterson

You'll have to change the formula:

=sheet99!a1
becomes
=if(sheet99!a1="","",sheet99!a1)
 
Top