+ Reply to Thread
Results 1 to 2 of 2

Compare/Match values by certain criteria (Vendor Number and System)

  1. #1
    Registered User
    Join Date
    09-23-2013
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2010
    Posts
    6

    Compare/Match values by certain criteria (Vendor Number and System)

    Please take a look and review the attached file, I'm in need of a VBA solution that will compare and match Val.Amt (Col F) value by Vendor, offseting the positive and negative values within each system (Col A)..see green (perfect match) and orange (variance due to forex rates) examples within the file.

    I need the matched rows to be highlighted and copied/paste to a new sheet.

    Any suggestions are appreciated….THANKS.

    CompareExample.xlsx

  2. #2
    Registered User
    Join Date
    09-23-2013
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Compare/Match values by certain criteria (Vendor Number and System)

    Disregard the system criteria, rather focus on comparing/matching by vendor. - THANKS

+ 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. trying to match vendor to lowest price
    By gmarma in forum Excel General
    Replies: 8
    Last Post: 11-14-2012, 01:35 AM
  2. [SOLVED] compare cell value with range of values and match row values with header
    By bujji1305 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-08-2012, 12:19 AM
  3. Replies: 5
    Last Post: 09-22-2009, 06:11 PM
  4. Match/Compare values in Worksheets
    By ExcelNovice1973 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-22-2007, 02:46 PM
  5. Replies: 0
    Last Post: 08-25-2005, 05:55 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