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
Bookmarks