In C20 enter =IF(Sheet1!A1="","",Sheet1!A1)

Means if Sheet1!A1 is blank, return a blank, else return what is in A1

If in another workbook, preface the range with the workbook name also

=IF([Book2]Sheet1!A1="","",[Book2]Sheet1!A1)

Copy across to M20 then down to M383


Gord Dibben MS Excel MVP

On Mon, 2 Feb 2009 09:44:01 -0800, OC wrote:

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,