How do I link to a blank cell without linked cell displaying "0"

[Guest]

I want to paste link a master data worksheet so I can sort by different categories and have linked sheets updated when I change or enter new date in master sheet. Can this be done?

 

[Frank Kabel]

Hi
try something like
=IF('sheet'!A1="","",'sheet'!A1)