One way is to use an IF statement rather than a straight link.

Insert =IF(Sheet1!A1="","",Sheet1!A1) in cell A1 of both Sheets 2 & 3
and then copy them across the entire range. This will make all blank
cells on Sheet 1 appear blank on Sheets 2 & 3 and should still work
okay with filters & sums.

Not sure if there's a way to do this by formatting 0s to be blanks,
perhaps someone else can address that?

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=528152