Linked cells - why '0' when blank?
 

I have a summary sheet & 2 detail sheets in the same workbook. I want the
header info from the summary sheet to copy to the 2 detail sheets. I've
linked the cells, but the problem is - when the summary sheet cell is blank,
the cells on the detail sheets show a '0'. Hwo can I get them to stay blank?
--
-Lynn F. PMP

Linked cells - why '0' when blank?
 

Hi,
click in the Microsoft button, Excel options, advance,Display options for
this workbook, uncheck Show a Zero in cell that have zero value

if this helps please click yes, thanks

"Lynn" wrote:

I have a summary sheet & 2 detail sheets in the same workbook. I want the
header info from the summary sheet to copy to the 2 detail sheets. I've
linked the cells, but the problem is - when the summary sheet cell is blank,
the cells on the detail sheets show a '0'. Hwo can I get them to stay blank?
--
-Lynn F. PMP

Linked cells - why '0' when blank?
 

Use something like this:

=IF(Sheet1!A1="","",Sheet1!A1)

Hope this helps.

Pete

On Aug 17, 3:46*pm, Lynn wrote:
I have a summary sheet & 2 detail sheets in the same workbook. *I want the
header info from the summary sheet to copy to the 2 detail sheets. *I've
linked the cells, but the problem is - when the summary sheet cell is blank,
the cells on the detail sheets show a '0'. *Hwo can I get them to stay blank?
--
-Lynn F. PMP

Linked cells - why '0' when blank?
 

=if(summary!a1="","",summary!a1)

is a way to avoid this.

Lynn wrote:

I have a summary sheet & 2 detail sheets in the same workbook. I want the
header info from the summary sheet to copy to the 2 detail sheets. I've
linked the cells, but the problem is - when the summary sheet cell is blank,
the cells on the detail sheets show a '0'. Hwo can I get them to stay blank?
--
-Lynn F. PMP

--

Dave Peterson