Pasting Links

S

shertay

How do paste links from one worksheet to another worksheet in the same
workbook with out it changing info or adding "0" in blank cells.
 
D

Debra Dalgleish

When you Paste Link, it creates a reference to the original cell.
For example: =A1

You can modify the formula: =IF(A1="","",A1)
 
Top