+ Reply to Thread
Results 1 to 4 of 4

Macro to Compare two columns and publish sheet name in case columns dont match

  1. #1
    Registered User
    Join Date
    09-26-2010
    Location
    A, A
    MS-Off Ver
    Excel 2003
    Posts
    86

    Macro to Compare two columns and publish sheet name in case columns dont match

    Hi All,

    Need help with the attached workbook, in the attached workbook I need a macro which will select the field "INS" in the Column with name "CMP_STATE", then compare Columns "VID" and "CMP_VID". In case the values do not match in every row of these columns, i need that sheet names to be published on a new sheet named "Missing".

    Attached is the test file,

    Thanks,
    Abhi
    Attached Files Attached Files

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,776

    Re: Macro to Compare two columns and publish sheet name in case columns dont match

    Hi Abhi. Create a sheet and name it "Missing" and then try this macro:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Registered User
    Join Date
    09-26-2010
    Location
    A, A
    MS-Off Ver
    Excel 2003
    Posts
    86

    Re: Macro to Compare two columns and publish sheet name in case columns dont match

    Great, this works... but could you add another line in the macro which would first create a sheet named "Missing".

    Thanks,
    Abhi

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,776

    Re: Macro to Compare two columns and publish sheet name in case columns dont match

    How about:
    Please Login or Register  to view this content.

+ 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. Replies: 1
    Last Post: 06-18-2013, 06:32 PM
  2. Replies: 20
    Last Post: 04-15-2013, 01:06 PM
  3. Replies: 1
    Last Post: 10-04-2012, 02:31 PM
  4. Replies: 9
    Last Post: 06-04-2012, 08:00 AM
  5. Replies: 4
    Last Post: 04-05-2012, 11:30 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