With the space in the sheet name you have to add some single quotes.
=IF('Interview Mail-in'!D5="","",'Interview Mail-in'!D5)
Excel requires these when sheet names or workbook names have spaces.
Next time I'll try to remember to post that info.
Gord Dibben MS Excel MVP
On Fri, 5 Oct 2007 14:31:04 -0700, CarlaP
wrote:
Gord,
Thanks for the suggestion. This didn't work either. Here is the formula I
entered:
=IF(Interview Mail-in!D5="","",Interview Mail-in!D5)
The name of the sheet that contains the original cell is - Interview Mail-in
and the cell is D5. When I enter this formula, the second cell has #NAME? in
it. If I enter information in the original cell, the second cell still has
#NAME? in it.
It's a mystery.
Carla
"Gord Dibben" wrote:
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