I'm sure this works ... but not sure I understand what to do ... sorry to ask
I'm assuming I paste this formula in the main workbook. My range is from
c20:m383.

Can you help?



"John" wrote:

Hi
Something like this : =if(sheet1!a1="","",your formula. change range to your
need.
HTH
John
"OC" wrote in message
...
I have two spreadsheets linked together as vacation planners....the
worksheet
cells that the link is copied to default to "0"....I am wondering if there
is
a way to still have the sheets linked but that the cell stays blank vs. a
"0"
and would only reflect the actual entry once entered in the main
spreadsheet.

Thank you,