linking cells

P

paula

I have a calendar created in Excel - each sheet is a new
month that contains the following information: the last
week of the previous month, the current month, and the
first week of the next month. I would like to link the
cells from the "overlapping" weeks, but I do not want
the "0" to show up in the cells. Is there any way to
prevent this? Thanks in advance!
 
G

Gord Dibben

Paula

Either choose not to show zero values through Tools>Options>View or trap the
zero and turn to a blank-looking character.

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

Gord Dibben Excel MVP
 
G

Guest

Thank you Gord - could I ask another? Do I need to link
these cells individually, or if I have a series of
columns and rows that need repeating, can I do it all at
once? Thanks!
-----Original Message-----
Paula

Either choose not to show zero values through Tools>Options>View or trap the
zero and turn to a blank-looking character.

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

Gord Dibben Excel MVP
Click to expand...
 
G

Guest

And sorry - another - if I've applied Styles to these
cells, can the style be linked too?
-----Original Message-----
Paula

Either choose not to show zero values through Tools>Options>View or trap the
zero and turn to a blank-looking character.

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

Gord Dibben Excel MVP
Click to expand...
 
G

Gord Dibben

You can select entire columns and/or rows or ranges and Copy>Paste
Special>Paste Links.

But that won't enter a zero-trappable formula when you paste.

You can enter the zero-trap formula on target sheet in say A1 then drag/copy
to other cells.

Gord

Thank you Gord - could I ask another? Do I need to link
these cells individually, or if I have a series of
columns and rows that need repeating, can I do it all at
once? Thanks!
Click to expand...
 
G

Gord Dibben

In a separate operation you could Paste Special>Formats after you have pasted
the links.

Gord

And sorry - another - if I've applied Styles to these
cells, can the style be linked too?
Click to expand...
 
Top