+ Reply to Thread
Results 1 to 5 of 5

Mirror Cells for edits to be replicated both ways

  1. #1
    Registered User
    Join Date
    04-26-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    18

    Post 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

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,651

    Re: Mirror Cells for edits to be replicated both ways

    Try this:-
    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,858

    Re: Mirror Cells for edits to be replicated both ways

    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
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    11-27-2019
    Location
    Lima, Peru
    MS-Off Ver
    Office 365
    Posts
    1

    Re: Mirror Cells for edits to be replicated both ways

    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

  5. #5
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,858

    Re: Mirror Cells for edits to be replicated both ways

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Mirror cells - two worksheets, random cells. Attempted code provided
    By ld2x07 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-18-2014, 09:30 AM
  2. Replies: 1
    Last Post: 02-27-2013, 04:16 AM
  3. [SOLVED] How to add counter to monitor numberof edits and copy this data in diff cells??
    By CHETANHADIMANI in forum Excel - New Users/Basics
    Replies: 27
    Last Post: 07-20-2012, 02:25 PM
  4. Userform that pulls and Edits cells
    By brouhaha501 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-01-2010, 04:00 PM
  5. What ways are there to tag cells and arrange by tags?
    By Advice Pro in forum Excel General
    Replies: 2
    Last Post: 03-27-2009, 06:52 PM
  6. Some locked cells still allow edits
    By Brigitte_P in forum Excel General
    Replies: 1
    Last Post: 07-16-2007, 07:03 PM
  7. replicated data in multiple cells on multiple worksheets
    By nam in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-30-2007, 11:08 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1