How to "back-to-back" Referencing?

[palomaaa]

Hi guys,

Is it possible to do a "back-to-back" referencing? (am not sure if this is the right term)

In C1, I want to get the VALUE of A1 when I enter a TEXT in A1.

If the TEXT needs to be entered in C1, I want A1 to get it, too.

Is this possible?

Thanks in advance.

[kvsrinivasamurthy]

In C1 enter this formula

=A1

[jaslake]

Hi palomaaa

Welcome to the Forum!

In the worksheet module place this code

Please Login or Register  to view this content.