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
Bookmarks