Results 1 to 7 of 7

Comparing two columns in two different sheets to find duplicate

Threaded View

  1. #1
    Registered User
    Join Date
    04-18-2012
    Location
    Vienna, Va
    MS-Off Ver
    Excel 2003
    Posts
    5

    Comparing two columns in two different sheets to find duplicate

    I have been trying to work on this all day and I am getting now where. Any help would be greatly appreciated.

    Basically I have data in two different sheets and would like to find the duplicates in sheet 1 and sheet 2, both column A. Sheet 1 has data that will change month to month while sheet 2's data will be constant. I would like to compare sheet 2, column A to sheet 1, column A and if there is a match, then pull the matching data from sheet 1 to sheet 3. (There will be multiple data on sheet 1, that will have the same number from sheet 2)

    It would be great if I could get this to be automated, so that I can just drop in the data for sheet 1 each month and have it do it all.

    I have included a sample sheet.

    Any help would be amazing

    Thanks
    Attached Files Attached Files

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