Paste "Link" without Empty Cells

[FinPro]

Hello,

I have a sheet that I want to copy to another file and past as Link. The sheet contains Formula, Constant and links to another file as well as blank cells. I want to skip these blank cells while pasting as link.

Currently when I paste as link, the empty cell cause a 0 (zero) displayed on target sheet and I had to delete these zeros manually. GOTO Special Visible Cells, Formula or Constant did not work since one leaves the other!

Thanks in advance for help.