Sharing and linking text data across multiple worksheets
Posted by Dave Scott on August 15, 2000 10:35 PM
I want to have the first sheet as a source for multiple sheets to follow.
I can copy and paste special> paste link, but when there is a blank cell in the sourceit puts a "0" in the target cell.
Is ther a way to make the target cell(s) blank also?
TIA
Posted by Ryan on August 16, 0100 7:23 AM
Dave,
Try this:
Assuming Source is Sheet1 "A1" and Target is Sheet2 "A1". In Target Cell put this:
If(Sheet1!A1 <> "",Sheet1!A1, "")
Hope this helps!
Ryan
