"0" in pasted link

J

Joanna

Hi,
I'm linking rows in my master worksheet to rows in another worksheet. I'm
using the "paste link" method. How can I prevent "0"s from appearing in the
blank cells?

And when I "paste link" to my nonmaster worksheet the wrap text format
doesn't paste over. How can I make the text wrap w/o having to individually
go into each cell to make it wrap?
 
D

Dave Peterson

You can modify the formula:

Instead of
=sheet2!a1
you can use:
=if(sheet2!a1="","",sheet2!a1)
 
Top