+ Reply to Thread
Results 1 to 3 of 3

Linking/Tie Cells Together

  1. 06-14-2021, 03:55 PM #1
    mstark17
    mstark17 is offline
    Registered User
    Join Date
    03-26-2021
    Location
    Fort Worth, TX
    MS-Off Ver
    365
    Posts
    51

    Linking/Tie Cells Together

    Is it possible to link 2 cells together so if I change the value of one it will change the value of another? For example, if on sheet 1 (A1) I put in 10, then on sheet 2 (B2) the value in that cell will be 10. The same goes vice versa where if on sheet 2 (B2) I put in 5, then it puts 5 on sheet 1 (A1). Is this possible?
    Reply With QuoteRegister To Reply
  2. 06-14-2021, 04:35 PM #2
    TMS
    TMS is online now
    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,366

    Re: Linking/Tie Cells Together

    Is this possible?
    Not without VBA. A cell can have a formula or a value, but not both. So you can link one cell to another cell on a different sheet using a formula but it can't be two way.
    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 With QuoteRegister To Reply
  3. 06-15-2021, 12:52 PM #3
    ByteMarks
    ByteMarks is offline
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    365 32bit Win
    Posts
    1,907

    Re: Linking/Tie Cells Together

    Similar scenario was raised here.
    https://www.excelforum.com/excel-pro...duplicate.html
    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. Linking cells stops unwrapped text flowing to adjacent empty cells
    By piecevcake in forum Excel General
    Replies: 0
    Last Post: 12-30-2015, 04:17 PM
  2. [SOLVED] Linking cells globally to allow users the ability to change cells on separate sheet/cells.
    By V1gilante in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2014, 10:47 PM
  3. [SOLVED] Linking cells from one sheet to another and update cells accordingly based on selection
    By hcyeap in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-17-2013, 09:53 AM
  4. Cells linking but not linking
    By Cnocell7 in forum Excel General
    Replies: 12
    Last Post: 12-19-2012, 03:59 PM
  5. Linking cells by looking up part of link in other cells
    By C_Fred in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-03-2008, 05:01 AM
  6. Linking single cells to related groups of cells?
    By rykey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-10-2007, 05:43 PM
  7. Linking a horizontal set of cells to a vertical sets of cells
    By Russell-stanely in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-21-2005, 11: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1