"copy and paste special as link"


--


Regards,


Peo Sjoblom


"Peo Sjoblom" wrote in message
...
If simplicity is what you want why not just copy and special as link.
Having said that I would go for Max;s solution any day


--


Regards,


Peo Sjoblom



"Dwight N" wrote in message
...
I think Max is right, it's more elegant. But Stephen is right too.
Simpler
is better. I use the simple format, then I go to tools, options, and
turn
off the show zero values.

"Max" wrote:

"Stephen" wrote:
Why not just use a simpler formula?
=Sheet2!A1

Because it's inferior to the classier:
=IF(Sheet2!A1="","",Sheet2!A1)

The simpler one will return ugly looking zeros for any blank cells in
Sheet2, while the classier one replicates it better by returning neat
looking
"blanks" for any blank cells in Sheet2. It also pre-empts the possible
follow-through question by the OP on the extraneous zeros being
returned. Why
not kill 2 birds with one arrow?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---