+ Reply to Thread
Results 1 to 3 of 3

How to make the contents of two cells completely interchangable

  1. #1
    Registered User
    Join Date
    11-07-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    76

    How to make the contents of two cells completely interchangable

    Such that, cells A1 and A2 both contain the same entry.

    For example, if you type the word in CAT in A1, it will appear in A2.
    Then if you immediately typed the word DOG in A2, it would replace the word CAT in A1


    Is this possible without the use of VBA?

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: How to make the contents of two cells completely interchangable

    Cells can contain a formula or a value, not both.
    VBA is your only solution.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    11-07-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: How to make the contents of two cells completely interchangable

    Thanks for confirming

+ 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. Excel 2007 : How can I make two cells completely equal
    By mloreto in forum Excel General
    Replies: 1
    Last Post: 10-20-2011, 11:33 PM
  2. Replies: 4
    Last Post: 02-15-2011, 04:46 PM
  3. Set up a Bar Graph with interchangable variables
    By Banner in forum Excel General
    Replies: 1
    Last Post: 09-07-2010, 07:49 AM
  4. An interchangable data cell in two separata worksheets?
    By burea1124 in forum Excel General
    Replies: 3
    Last Post: 02-03-2009, 02:13 AM
  5. [SOLVED] Are macros interchangable between Excel and Access???
    By Ray via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-08-2005, 08: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