+ Reply to Thread
Results 1 to 5 of 5

Bi-directional data mirroring (?)

  1. #1
    Registered User
    Join Date
    02-03-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question Bi-directional data mirroring (?)

    Hi,

    I'm fairly good with excel, but can't work out if there's an easy way to do the following :-

    as an example :

    If text data is entered into cell b7 then it copies/mirrors it into cell G7, but ALSO if data is entered into cell G7 instead, then it mirrors it back to b7....

    (does that make sense?)

    Many thanks in advance....

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,632

    Re: Bi-directional data mirroring (?)

    As you are writing, there is probably some rationale behind.
    Normally it makes no big sense, but if you need it, a simple procedure with Event Handler for Worksheet Change event could do it.

    for instance (in your sheet code):
    Please Login or Register  to view this content.
    see attachment
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    05-18-2017
    Location
    Chicago, IL
    MS-Off Ver
    excel 2013
    Posts
    1

    Question Re: Bi-directional data mirroring (?)

    so the next step in this prosess is to be able to share the information between numerous sheets, and consolidate some information..
    this is how i tried it- but its not working.
    any thoughts?


    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Sheet1.Select.Range("b2:n2")) Is Nothing Then
    Application.EnableEvents = False
    Sheet2.Select.Range("a13:m13").Value = Sheet1.Select.Range("b2:n2").Value
    Application.EnableEvents = True
    End If
    If Not Intersect(Target, Sheet2.Select.Range("a13:m13")) Is Nothing Then
    Application.EnableEvents = False
    Sheet1.Select.Range("b2:n2").Value = Sheet2.Select.Range("a13:m13").Value
    Application.EnableEvents = True
    End If

    End Sub

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,632

    Re: Bi-directional data mirroring (?)

    Sorry, at the moment no merit answer, because your do double violation.
    See our https://www.excelforum.com/forum-rul...rum-rules.html and focus on (+ follow) rules 2 and 3

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Bi-directional data mirroring (?)

    Quote Originally Posted by TechMerc911 View Post
    so the next step in this prosess is to be able to share the information between numerous sheets, and consolidate some information..
    this is how i tried it- but its not working.
    any thoughts?
    Please take the time to review our rules. There aren't many, and they are all important.

    Your post does not comply with Rule 3 of our Forum Rules: Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


    Your post does not respond to the original question, but rather expands the topic and goes in another direction. [/B]Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Sheet mirroring: keyword filtered mirroring from sheet 1 to sheet 2
    By Choffe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2013, 08:02 AM
  2. Mirroring Data in 2 different worksheets.
    By nanomess in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-03-2013, 01:44 PM
  3. Mirroring Data Labels
    By Netbrian in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-10-2010, 04:22 AM
  4. Mirroring vertical data horizontally.
    By DawnGL in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-20-2008, 11:04 AM
  5. Excel Mirroring Data
    By mickp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-21-2006, 01:40 AM

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