rrtts
11-21-2006, 03:40 PM
This seems like a ridiculously easy question but I can't seem to find an answer anywhere...or perhaps I already know the answer and just haven't accepted it yet.
I'm using the paste/special/link function to display cell contents from several cells to cells on a different worksheet. If a cell is empty, a zero "0" is displayed in the linked cell.
Is there a way to link the cells but if the cell is empty then nothing shows up at the linked cell location?
Or is there any other way to accomplish this?
Thanks.
I'm using the paste/special/link function to display cell contents from several cells to cells on a different worksheet. If a cell is empty, a zero "0" is displayed in the linked cell.
Is there a way to link the cells but if the cell is empty then nothing shows up at the linked cell location?
Or is there any other way to accomplish this?
Thanks.