+ Reply to Thread
Results 1 to 2 of 2

make 2 cells equal and editable

  1. #1
    Registered User
    Join Date
    06-21-2012
    Location
    Kansas
    MS-Off Ver
    Excel 2007
    Posts
    3

    make 2 cells equal and editable

    Hello, this is my first post so go easy on me! I have very little VB experience, so a built-in Excel function would be ideal.


    I have two cells on the same worksheet (A1 and A2) - both are using the same validation list for data entry ("First" and "Second").
    I would like to make both cells change value (to equal the other) when only one is modified using the drop down validation list.

    Example:
    Action 1) Choose "First" in cell A1 via validation drop down list.
    Result 1) A1 and A2 show "First".

    Action 2) Choose "Second" in cell A2 via validation drop down list.
    Result 2) A1 and A2 show "Second".

    Thank you in advance for the help.

  2. #2
    Registered User
    Join Date
    06-21-2012
    Location
    Kansas
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: make 2 cells equal and editable

    UPDATE:

    I just found the thread on another site referencing VBA code that will do what I'm wanting. Is there any chance of getting this done without VBA code?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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