MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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