Not without using VBA, ie macro code. You would have to have a change event
on each sheet that interrogated any change on the sheet to see if it was the
cell in question, and if indeed it was then it would write the same value
into the corresponding cell on the other sheet. This cannot be done with
formulas.

If you are unable to run macros in your work environment then you would be
unable to go this route.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"ksks16" wrote in
message ...

I am trying to link 2 worksheets to each other. By copying cell A1 in
Sheet 2 and pasting it as a link to cell A1 in Sheet 1 - I can make
changes to my data ONLY by updating it in Sheet 2. If I update data
in Sheet 1 it simply replaces the created link with my typed data.
Data is text.


Is there a way to "connect" these two cells so I can update data in
EITHER place and it will automatically update the other - without being
forced to always return to my original Sheet 2?

HELP!!!
-ksks16


--
ksks16
------------------------------------------------------------------------
ksks16's Profile:
http://www.excelforum.com/member.php...o&userid=30841
View this thread: http://www.excelforum.com/showthread...hreadid=505045