I'm trying to link a blank cell (which will eventually contain text) to
another blank cell - different sheet but same workbook. The result is always
a "0" in the new cell. I've cleared both cells of all contents and formatting
to no avail.

I'm using Excel 2003. I'm grateful for any assistance.

Try it like this:
=IF(Sheet2!A1="","",Sheet2!A1)

instead of: =Sheet2!A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CarlaP" wrote:
I'm trying to link a blank cell (which will eventually contain text) to
another blank cell - different sheet but same workbook. The result is always
a "0" in the new cell. I've cleared both cells of all contents and formatting
to no avail.

I'm using Excel 2003. I'm grateful for any assistance.

Thanks, Max. Unfortunately it didn't work.
Carla

"Max" wrote:

Try it like this:
=IF(Sheet2!A1="","",Sheet2!A1)

instead of: =Sheet2!A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CarlaP" wrote:
I'm trying to link a blank cell (which will eventually contain text) to
another blank cell - different sheet but same workbook. The result is always
a "0" in the new cell. I've cleared both cells of all contents and formatting
to no avail.

I'm using Excel 2003. I'm grateful for any assistance.

Did you use the name of your worksheet to which you are linking? Might not
be sheet2.
Did you type the formula correctly?

If in cell B6 on Sheet1, you're linking to cell C14 on a worksheet named
Calcs2006, your formula in cell B6 on sheet1 has to be:
=IF(Calcs2006!C14="","",Calcs2006!C14)

Tyro

"CarlaP" wrote in message
...
Thanks, Max. Unfortunately it didn't work.
Carla

"Max" wrote:

Try it like this:
=IF(Sheet2!A1="","",Sheet2!A1)

instead of: =Sheet2!A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CarlaP" wrote:
I'm trying to link a blank cell (which will eventually contain text) to
another blank cell - different sheet but same workbook. The result is
always
a "0" in the new cell. I've cleared both cells of all contents and
formatting
to no avail.

I'm using Excel 2003. I'm grateful for any assistance.

I'd love to know exactly what "didn't work" means.

Wrong return ... NO return ... XL crashed ! ! !

Can you describe what you mean?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"CarlaP" wrote in message
...
Thanks, Max. Unfortunately it didn't work.
Carla

"Max" wrote:

Try it like this:
=IF(Sheet2!A1="","",Sheet2!A1)

instead of: =Sheet2!A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CarlaP" wrote:
I'm trying to link a blank cell (which will eventually contain text) to
another blank cell - different sheet but same workbook. The result is
always
a "0" in the new cell. I've cleared both cells of all contents and
formatting
to no avail.

I'm using Excel 2003. I'm grateful for any assistance.

It should have worked ok, Carla.
Maybe try it again, after your break?
Let us know further how it went ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CarlaP" wrote:
Thanks, Max. Unfortunately it didn't work.
Carla

Hi all,

Thanks for your suggestions. To clarify, here are the steps I am following
(according to Excel Help):
- I select the cell which contains the information (it actually has nothing
in it but will eventually contain text)
- I copy (Control c)
- I go to cell on different worksheet (same workbook) that I want to
contain info from original cell
- I paste (Contol p)
- I click the resulting icon in the lower right corner of the cell that
looks like a little clipboard and select the option "link cells."
- The appropriate formula shows up in the formula bar.
Here is the problem:
Unless I make an entry in the original cell, the seond cell has a "0" in it.
If I do make an entry in the original cell, the linked cell will show that
entry. This workbook is a template and I do not want that "0" to be visible!
I have followed the above procedure with other workbooks without difficulty
and cannot figure out why this one isn't cooperating.
Any ideas?

Thanks again!

"Max" wrote:

It should have worked ok, Carla.
Maybe try it again, after your break?
Let us know further how it went ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CarlaP" wrote:
Thanks, Max. Unfortunately it didn't work.
Carla

You have to do the linking manually and add a blank cell trap.

In Sheet2 select a cell and enter =IF(Sheet1!A1="","",Sheet1!A1)


Gord Dibben MS Excel MVP

On Fri, 5 Oct 2007 13:45:01 -0700, CarlaP
wrote:

Hi all,

Thanks for your suggestions. To clarify, here are the steps I am following
(according to Excel Help):
- I select the cell which contains the information (it actually has nothing
in it but will eventually contain text)
- I copy (Control c)
- I go to cell on different worksheet (same workbook) that I want to
contain info from original cell
- I paste (Contol p)
- I click the resulting icon in the lower right corner of the cell that
looks like a little clipboard and select the option "link cells."
- The appropriate formula shows up in the formula bar.
Here is the problem:
Unless I make an entry in the original cell, the seond cell has a "0" in it.
If I do make an entry in the original cell, the linked cell will show that
entry. This workbook is a template and I do not want that "0" to be visible!
I have followed the above procedure with other workbooks without difficulty
and cannot figure out why this one isn't cooperating.
Any ideas?

Thanks again!

"Max" wrote:

It should have worked ok, Carla.
Maybe try it again, after your break?
Let us know further how it went ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CarlaP" wrote:
Thanks, Max. Unfortunately it didn't work.
Carla