copy cell information - both ways - cell link

[rubz71]

Hi,

I am trying to copy cell information between two worksheet. The only catch is i want it done both ways. Meaning, if i change the value of selected cell in woksheet 1, it would update the value of same cell in worksheet 2 and vice versa.

worksheet 1
a1 3
a2 5
a3 7

worksheet2
a1 3
a2 5
a3 7

Regardless, which cell i am in, if value of a1 is updated to 4 from 3, it would update in both worksheet 1 and 2. This is easily describable with "cell link" functionality with check boxes under format cell.

If your help is appreciated. Thanks!

[:) Sixthsense :)]

Do right click on sheet1 Sheet Tab and select view code and paste the below code

Please Login or Register  to view this content.

Do right click on sheet2 Sheet Tab and select view code and paste the below code

Please Login or Register  to view this content.

Change the sheet Names (Sheet1, Sheet2) to your desired sheets.

[rubz71]

Hi Sixthsense,

Thanks for your reply..it works fine..However, what if i wish to copy only one cell instead of the entire column information..

Example: only copy the B3 cell value..which is a3 n value is 7..thanks..

[:) Sixthsense :)]

Example: only copy the B3 cell value..which is a3 n value is 7..thanks..

I am not clear about your above statement can you please elaborate it?