Linking Text cell comments to cells on other sheets in same book.

  • Thread starter Thread starter Cpl Bowen
  • Start date Start date
C

Cpl Bowen

Heres my dilemma: I want to automate a task of updating
the same information across several sheets (name, age,
etc across the top of a form.) When the user changes
their info on the first sheet, I want the cells holding
the same information on other sheets to update
automatically.

I have successfully done this with the Age cells (numbers
work fine), however it doesn't work with the Name cells.
I'm assuming this is due to the inherent characteristics
of the cells being formatted as Text. For the number
cells, I just linked the other cells to the first cell
that the user updates. How can I achieve this with the
Text cells?
 
Above Subject Line is wrong, should read:
Linking Text cell CONTENTS to cells on other sheets in
same book.
 
Why can't you just link the text cells in the same way?
What problems are you encountering with linking the text?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


Heres my dilemma: I want to automate a task of updating
the same information across several sheets (name, age,
etc across the top of a form.) When the user changes
their info on the first sheet, I want the cells holding
the same information on other sheets to update
automatically.

I have successfully done this with the Age cells (numbers
work fine), however it doesn't work with the Name cells.
I'm assuming this is due to the inherent characteristics
of the cells being formatted as Text. For the number
cells, I just linked the other cells to the first cell
that the user updates. How can I achieve this with the
Text cells?
 
The way I link the number cells is: ='sheetname'!cellname
The number cell sees the equal sign and picks it up.
However the Text cells are purely for text and do not see
the equal sign as being a command, therefore when I type
the above into a Text-formatted cell, it actually just
writes "='sheetname'!cellname" into the cell, not link it.
 
Is there a particular reason why you wish the cell to be formatted as
'Text"?

Try this:
Select one of the cells that has this text formula in it and,
<Ctrl> <Shift> <~>,
Then,
<F2> <Enter>

This is just a quick way to format the cell to "General", and then edits the
cell so that it recognizes the "new" format.

You should be able format all your text cells to "General" which allows your
linking formulas to work, while displaying your text entries as text.

So, back to the top and ... is there a reason?
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


The way I link the number cells is: ='sheetname'!cellname
The number cell sees the equal sign and picks it up.
However the Text cells are purely for text and do not see
the equal sign as being a command, therefore when I type
the above into a Text-formatted cell, it actually just
writes "='sheetname'!cellname" into the cell, not link it.
 
Upon further evaluation, the problem seems to be that the
original cell that others refer to is a merged cell.
When doing the same thing with a text cell that is only
one cell, it works. How can I get around this?
 
No, there is no specific reason it needs to be text.

I tried what you said, and it returns a number ( 0 ).

I think the problem lies in the fact that the contents im
trying to link to other cells is in a merged cell.
 
*Don't* use merged cells unless *absolutely* necessary, where no other
alternatives are available.
You're seeing here only one of the numerous other problems presented by
using merged cells.

Have you tried using "CenterAcrossSelection" instead?
Select the cells in question, then,
<Format> <Cells> <Alignment> tab,
Expand the "Horizontal" box and choose,
"CenterAcrossSelection", then <OK>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Upon further evaluation, the problem seems to be that the
original cell that others refer to is a merged cell.
When doing the same thing with a text cell that is only
one cell, it works. How can I get around this?
 
Zero (0) means the cell you linked to is empty (blank).
--

Regards,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

No, there is no specific reason it needs to be text.

I tried what you said, and it returns a number ( 0 ).

I think the problem lies in the fact that the contents im
trying to link to other cells is in a merged cell.
 
Back
Top