+ Reply to Thread
Results 1 to 3 of 3

Creating two linked interdependent cells

  1. 02-24-2020, 12:51 AM #1
    Felixthefox
    Felixthefox is offline
    Registered User
    Join Date
    02-21-2020
    Location
    Germany
    MS-Off Ver
    MS Office 2016
    Posts
    3

    Exclamation Creating two linked interdependent cells

    Hello everyone,
    I am working on a calculator and want to link 2 cells together dependent from another cell.

    Example:

    A1-B1=C1 and A1-C1=B1

    I want to decide in which cell i want change the value (B1 or C1) and then i want it to calculate the other one automatically.

    Does someone has an idea how this could work with a formula?

    Thanks a lot!
    Attached Files Attached Files
    Last edited by Felixthefox; 02-25-2020 at 02:30 AM.
    Reply With QuoteRegister To Reply
  2. 02-24-2020, 01:39 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Creating two linked interdependent cells

    Cannot be done with formulas, will need VBA
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 02-24-2020, 01:46 AM #3
    Felixthefox
    Felixthefox is offline
    Registered User
    Join Date
    02-21-2020
    Location
    Germany
    MS-Off Ver
    MS Office 2016
    Posts
    3

    Re: Creating two linked interdependent cells

    How can I do it with VBA?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. creating Linked cells from current workbook Dynamically with multiple cell values
    By 2k05gt in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-03-2017, 04:48 PM
  2. [SOLVED] Creating a macro to create multiple check boxes linked to different cells
    By clabhart in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2014, 12:50 PM
  3. Creating two "interdependent, linked" cells on a spreadsheet
    By boom929 in forum Excel General
    Replies: 3
    Last Post: 03-05-2014, 04:33 PM
  4. Creating interdependent list from a serie of references
    By sickcat in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2013, 09:56 PM
  5. Multiple Interdependent Cells
    By rcxtcx in forum Excel General
    Replies: 1
    Last Post: 04-25-2013, 04:32 PM
  6. Creating a Template Printing Page or a clever way of copying linked cells
    By SHS in forum Excel General
    Replies: 3
    Last Post: 08-13-2009, 03:30 PM
  7. Linked Cells Staying With Cells Once Linked Workbook Update.
    By [email protected] in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-06-2006, 04:40 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1