Pasting Links
 

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.

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

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


shertay wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html