Paste Link Command

Posted by Jan on December 28, 2001 11:12 AM

I'm trying to reference information from a master list to a separate worksheet. the information is text and has some blank cells. The problem is that when i copy the info and then use the (paste link) command on the separate worksheet the blank cells from the master list are filled with a zero on the reference sheet. Is there any way around this?????

Thanks.

Posted by IML on December 28, 2001 1:07 PM

Since no one's offer a good solution, you could do this by formual.

Lets say you want to bring the items from sheet 1 to another sheet. Put in the formula
=IF(ISBLANK(Sheet1!A1),"",Sheet1!A1)

substitute whatever the actual cell is for A1. Now copy this formula to the capture the whole range you wanted.

Good luck.