+ Reply to Thread
Results 1 to 3 of 3

Fastest way to compare two sheets and copy matches

  1. #1
    Registered User
    Join Date
    08-18-2010
    Location
    Belo Horizonte, Brasil
    MS-Off Ver
    Excel 2007
    Posts
    12

    Fastest way to compare two sheets and copy matches

    Hello, im having some trouble comparing equal values between two sheets. I need to search a sheet, find a value, compare to another one and if found on the other one, copy to a new sheet. Ive found a few codes that search the sheets but they are very slow.. so whats the fastest? I have around 60k rows to search on a column and 5k to search on the other. Another thing apart, how do i find the word "function" and create a copy range from there on until the last populated row? Thank you

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Fastest way to compare two sheets and copy matches

    Please post a sample workbook.

  3. #3
    Registered User
    Join Date
    08-18-2010
    Location
    Belo Horizonte, Brasil
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Fastest way to compare two sheets and copy matches

    There. The thing i mentioned is to compare sheet 2 with sheet 1 returning to sheet 3 the exact values of sheet 2 found on sheet 1. But row by row takes too long. Thank you
    Attached Files Attached Files

+ 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