Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Matcher.xla by Zach (zfraile)


posted by Admin
Thu, Jan 10 2008

Downloads: 192
File size: 205.5kB
Views: 681
Matcher.xla by Zach (zfraile)

This add-in I put together to match records among two files.  It reads the top row as field headers and allows you to designate different combinations of fields as unique to be matched against the other file.  I've used it for reconciling credit card transactions to ledger entries and for matching patient visits between different billing systems.

Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.