Same info in a cell in sheet1 and sheet2?

[Kristian]

Hello. I have this problem, which I am pretty sure need to get
programmet to work. Here goes;

I have a workbook containing 2 sheets; sheet1 and sheet2. I want the
cell A1 in sheet1 to contain the same info as cell C1 in sheet2, and
vice versa.

Eg. I enter the number 5 in cell A1 in sheet1. Then the number 5 also
entered in cell C1 in sheet2. And vice versa, when I enter for
instance 10 in C1 in sheet2, then 10 is entered in A1 in sheet1.

How can I program this?

Thanks in advance!

 

[Frank Kabel]

Hi Kristian
You may use the worksheet_change event (on both sheets) fot this. Have
a look at
http://www.cpearson.com/excel/events.htm

Note: I wouldn't do this. Select one sheet as the master and the other
only as view