Linking text
 

How can I link text to a cell reference?

Depreciation Asset - Cell D4

Linking text
 

On Insert Menu, go to NameDefine

You can type in the name and then in the "Refers To" box, enter the
cell reference.


HTH,
JP

On Jan 10, 2:37*pm, krc547 wrote:
How can I link text to a cell reference?

Depreciation Asset - Cell D4

Linking text
 

I have several cells, I didn't want to have to name each one.

"JP" wrote:

On Insert Menu, go to NameDefine

You can type in the name and then in the "Refers To" box, enter the
cell reference.


HTH,
JP

On Jan 10, 2:37 pm, krc547 wrote:
How can I link text to a cell reference?

Depreciation Asset - Cell D4

Linking text
 

Can you post some more examples, there is a VBA solution that would be
less tedious.


--JP

On Jan 10, 2:53*pm, krc547 wrote:
I have several cells, I didn't want to have to name each one.



"JP" wrote:
On Insert Menu, go to NameDefine

You can type in the name and then in the "Refers To" box, enter the
cell reference.

HTH,
JP

On Jan 10, 2:37 pm, krc547 wrote:
How can I link text to a cell reference?

Depreciation Asset - Cell D4- Hide quoted text -

- Show quoted text -