Links

[OC]

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,

 

[John]

Hi
Something like this : =if(sheet1!a1="","",your formula. change range to your
need.
HTH
John

 

[OC]

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]

HI OC
The cells that are showing 0 there is a formula in those cells.
Just add what i typed to your formula e.g. =if(sheet1!a1="","",
HTH
John

 

[Gord Dibben]

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