+ Reply to Thread
Results 1 to 11 of 11

Compare and exact match two columns data on two separate tabs in one spreadsheet

Hybrid View

chs Compare and exact match two... 06-29-2012, 03:12 PM
oeldere Re: Compare and exact match... 06-29-2012, 03:33 PM
xladept Re: Compare and exact match... 06-29-2012, 03:47 PM
chs Re: Compare and exact match... 07-03-2012, 03:47 PM
chs Re: Compare and exact match... 07-03-2012, 03:45 PM
oeldere Re: Compare and exact match... 07-03-2012, 04:07 PM
icestationzbra Re: Compare and exact match... 07-03-2012, 04:15 PM
chs Re: Compare and exact match... 07-10-2012, 11:37 AM
icestationzbra Re: Compare and exact match... 07-10-2012, 01:09 PM
chs Re: Compare and exact match... 07-10-2012, 02:45 PM
oeldere Re: Compare and exact match... 07-10-2012, 03:01 PM
  1. #1
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Compare and exact match two columns data on two separate tabs in one spreadsheet

    Hi chs,

    Here's a macro if you like:

    Sub ClassyStyle(): Dim r As Long, t As Long, u As Long
    Dim S As String, C As String, T2 As Worksheet
    Set T2 = Sheets(2)
    r = ActiveCell.row
    GetAnother:
    S = ActiveCell: C = ActiveCell.Offset(0, 1)
    With T2
    For t = r To Sheets(2).Cells(Rows.count, 1).End(xlUp).row
    If S = .Cells(t, 1) Then
    If C = .Cells(t, 2) Then
    .Cells(t, 3) = "Match"
    Else
    .Cells(t, 3) = "Mismatch"
    End If: End If
    Next t
    End With
    ActiveCell.Offset(1, 0).Select
    If ActiveCell = "" Then Exit Sub
    GoTo GetAnother
    End Sub
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  2. #2
    Registered User
    Join Date
    06-29-2012
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Compare and exact match two columns data on two separate tabs in one spreadsheet

    Thank you Xladept,

    I am not that advanced yet, but I will certainly save it for future reference .
    Best,
    CHS

+ 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