+ Reply to Thread
Results 1 to 2 of 2

Linked cells that mirror eachother, without circular references

  1. #1
    Registered User
    Join Date
    01-03-2015
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    55

    Linked cells that mirror eachother, without circular references

    Hi,
    'Tis a similar problem to the
    a1: =b1/1.2
    b1: =a1*1.2

    for complimentary formulae for vat-inclusive and exclusive-columns, which produces a circular reference

    This is hard to explain but actually more straight-forward, as it's similar to the above but without the calculation

    I would like EITHER a1 or b1 to have data inputted, and for the other to show what the other does (unless conflicting data is written in each, which should only happen is formula are over-written with data anyway, and i'll use conditional formatting to warn me of any such conflicts)

    ie

    I enter Yes in A1, and B1 shows yes
    or
    I enter Yes in B1, and A1 shows yes

    make sense?
    thanks in advance

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,492

    Re: Linked cells that mirror eachother, without circular references

    The only way to do that is with a Worksheet Change event handler in VBA
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. Replies: 2
    Last Post: 02-23-2014, 06:06 PM
  2. [SOLVED] Multiple Dropdown Lists that are linked to eachother
    By MrWines in forum Excel General
    Replies: 4
    Last Post: 08-29-2013, 07:39 AM
  3. 2 identical sheets , linked to eachother?
    By stevnb in forum Excel General
    Replies: 4
    Last Post: 12-14-2012, 07:44 AM
  4. Non circular references
    By jammerculture in forum Excel General
    Replies: 8
    Last Post: 05-29-2010, 09:43 PM
  5. Circular References
    By frenzel2k in forum Excel General
    Replies: 0
    Last Post: 10-10-2007, 06:11 PM
  6. [SOLVED] Those Circular References...
    By JeremyH1982 in forum Excel General
    Replies: 4
    Last Post: 05-22-2006, 05:55 PM
  7. Dynamically linked the references used in different cells
    By 0-0 Wai Wai ^-^ in forum Excel General
    Replies: 2
    Last Post: 08-26-2005, 07:05 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