Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |