Mirror Cells for edits to be replicated both ways

Hi all,

I need to mirror two columns meaning effectively that all changes that are made in cell D3 are replicated in K3 and vice versa

I know that you can use the simple =d3 formula and that can be filled all the way down the collumns but that is one directional. I also need the changes to be replicated the other way round so if I change K3. D3 also updates.

All help will be much appreciated,

Many Thanks,

H

Try this:-

Please Login or Register  to view this content.

Hi hemal89,

You probably need some VBA code to do what you want. See the following code that is included in attached file.

In the Sheet code module (e.g. the code module for 'Sheet1'):

Please Login or Register  to view this content.

The following may help you if you are not familiar with Macros and VBA:

To enable Macros and to Run Macros see the following:
http://office.microsoft.com/en-us/ex...010031071.aspx
http://office.microsoft.com/en-us/ex...010014113.aspx
If help is still needed do a google search for 'youtube excel enable macro' and/or 'youtube excel run macro'.

To access Visual Basic (VBA) see:
http://www.ablebits.com/office-addin...a-macro-excel/
a. Click on any cell in the Excel Spreadsheet (may not be needed).
b. ALT-F11 to get to VBA.
c. CTRL-R to get project explorer (if it isn't already showing).
d. Double Click on a 'Module Name' in 'Project Explorer' to see code for that module.

To access a Sheet Module in VBA:
a. 'Left Click' on any cell in the Excel Spreadsheet.
b. ALT-F11 to get to VBA.
c. CTRL-R to get project explorer (if it isn't already showing).
d. 'Double Click' on the module you want to access in the 'Project Explorer'.
e. Insert code into the module if needed. 'Option Explicit' should only appear ONCE at the top of the module.

Lewis

I think that we've already solved this issue, but what if I'm trying to change the value of the cell with a spin button?? It doesn't update to the other cell

Administrative Note:

Welcome to the forum.

Please start a new thread, with your specific question. You will get the best and quickest answer if you upload a desensitized sample workbook that is not password protected in any way.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

Lewis

This was great help for me, but can this be done with rows instead of columns?