Link cells and keep formatting?

C

CB_0209

Is there any way to link a group of cells from one worksheet to another and
keep the formatting? I can get things to link, but blank cells turn into Os
and any cell color or merging cells is lost.

Thanks
 
G

Gary''s Student

Excel relies on using paste/special/format to bring over the formats and the
link to bring over the value.

You have to explicitly test for blank in the source to match it in the link.
 
Top