Results 1 to 5 of 5

Compare 2 columns and mark the duplicates

Threaded View

  1. #1
    Registered User
    Join Date
    03-11-2010
    Location
    Montreal, Canada
    MS-Off Ver
    Excel 2003
    Posts
    8

    Compare 2 columns and mark the duplicates

    I was wondering if there is anyway I could do something similar to Cells.Find(What:=Paste) in a macro. I want to compare two columns of cells, one on the first worksheet and the other on the second worksheet, and identify which one from the first sheet are in the second one.

    I tried recording a macro that would:
    1) take the first cell from the first column
    2) copy it (Ctrl+C)
    3) go to the second sheet
    4) paste it (Ctrl+V) in the "find" dialog box .. ***
    5) turn on relative references and press tabs to select the cell right next to the "found" cell
    6) type an "X"... or anything i'd like.. Shipped, received, missing blabla
    7) go back to the first sheet
    8) with relative references still turned on go down one cell
    9)and then loop the macro from step 2 till it reaches the last filled cell from the first column in the first sheet.

    ***That's what bugging me, Excel won't record "Ctrl+V" in the macro, so it would keep looking for the values it first pasted.. let's say that when I recorded the macro i "Ctrl+C" the first cell which contains "1", it would loop but instead of "Ctrl+V" the newly "Ctrl+C" value, it would keep looking for the "1"...

    So it didn't work..
    I'm still new with macros so google is my best pal at the momment but it seems google has its limits.

    Before Macro
    Sheet 1

    2
    3

    Sheet 2

    1
    2
    3
    4

    After Macro
    Sheet 1

    2
    3

    Sheet 2

    1
    2 x
    3 x
    4

    That's pretty much what i'd like to do.

    So if anybody knows of a better way to achieve such a thing, I'd be more than pleased to hear it.
    Last edited by powpowninjastar; 03-12-2010 at 10:07 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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