+ Reply to Thread
Results 1 to 7 of 7

Comparing 2 columns in a row of columns and identifying differences

  1. #1
    Registered User
    Join Date
    09-23-2014
    Location
    Detroit, MI
    MS-Off Ver
    office 10
    Posts
    16

    Comparing 2 columns in a row of columns and identifying differences

    Good evening,
    I am trying to compare 2 columns in a row of columns and would like a list to be generated on what changes were made. I figure I'd have 2 drop down menus. One is the "from" selection. The other is the "to" selection. I would then like a table to show stating "add X employee" or "remove X employee." Any help would be appreciated. Attached is an example of what I am trying to accomplish.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Comparing 2 columns in a row of columns and identifying differences

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-23-2014
    Location
    Detroit, MI
    MS-Off Ver
    office 10
    Posts
    16

    Re: Comparing 2 columns in a row of columns and identifying differences

    Thank you for the response. Would this be posted into the sheet code?

    Also, if you don't mind me asking, what does this line do exactly?

    Please Login or Register  to view this content.

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Comparing 2 columns in a row of columns and identifying differences

    The code would be copied too a Standard Module. It is not sheet code. The "i" is a variable used to increment down from row 4. Did you prefer sheet code?

  5. #5
    Registered User
    Join Date
    09-23-2014
    Location
    Detroit, MI
    MS-Off Ver
    office 10
    Posts
    16

    Re: Comparing 2 columns in a row of columns and identifying differences

    Oh no, what you did was just fine. Thank you. Is there a way to have it select what rows to compare based on the 2 drop down menus in G3 & I3?

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Comparing 2 columns in a row of columns and identifying differences

    Perhaps:

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    09-23-2014
    Location
    Detroit, MI
    MS-Off Ver
    office 10
    Posts
    16

    Re: Comparing 2 columns in a row of columns and identifying differences

    Good morning,
    I have been working with your code and I stumbled upon 1 error. If the duplicate values are not in the same row then it doesn't consider the values to be duplicate. For example, if you were to take Mark's name in either column 1 or 2 and move it, it wouldn't recognize it as a duplicate value anymore. Other than that error, it is everything I am looking for. Thank you for the major help.

+ 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. Comparing two columns in excel to find differences
    By Mary22 in forum Excel General
    Replies: 2
    Last Post: 08-19-2016, 03:23 AM
  2. Create Columns Comparing differences in Other Columns
    By mvannucci in forum Excel General
    Replies: 1
    Last Post: 08-02-2015, 07:56 PM
  3. Replies: 1
    Last Post: 02-08-2014, 04:34 PM
  4. Comparing 2 WB's with identical rows and columns, then Hightlight the differences
    By crispybadger in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2013, 05:17 PM
  5. Comparing two worksheets and identifying differences
    By sarahrose20 in forum Excel General
    Replies: 4
    Last Post: 07-24-2012, 08:26 AM
  6. Comparing differences between two columns
    By MI_Analyst in forum Excel General
    Replies: 1
    Last Post: 11-02-2010, 06:51 AM
  7. Comparing columns and highlighting differences
    By Sejrup in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-01-2010, 09:24 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