Subscribe for NewsLetters
Email: *
 
First Name: *
 
Last Name:
 
Organization:
 
Position:
 
Country:
Enter Captcha:*
captcha
Search_btn
Mktg 87124 Audit Net 468x60
Audit Net Digital Banner 728x90
Auditnet 728x90 Arbutus Banner 1[1]
Mktg 87124 Audit Net 468x60
Vendor Matching Workbook July 2014

Name

Vendor Matching Workbook July 2014

Description


Background: This macro performs 3 types of tests
Test 1: Exact Match on Full Address
Test 2: Similar Match on Full Address (this is a 'fuzzy' match. The macro will first remove 'spaces' and 'special characters' and then compare the addresses. You'll get more matches to review but might have some false positives.)
Test 3: Similar Match on Partial Address (this is a 'fuzzy' match. The macro will first remove 'spaces' and 'special characters' and then compare only the first 7 characters of each address. You'll get more matches to review but might have some false positives).

Instructions:
Step 1: Paste your employee address information into the 'Employee Address' tab using the column headers provided and following the example text provided
Step 2: Paste your vendor address information into the 'Vendor Address' tab using the column headers provided and following the example text provided
Step 3: Click the 'Run Macro' button below

Results: See 'Potential' Matches section. Use the 'Audit Tracking' numbers to trace matches back to the detail info in the 'Employee Addresses' tab and the 'Vendor Address' tab.

Reset Macro: Press the 'Reset Macro' button to prepare the macro for subsequent testing.

IT Audit Program

You need to login to add your comment

0 Comments

Download

This file is only available to premium subscribers or site license users. Please log in or sign up for a subscription to get this file.

Subscription Level

Premium

Type

Procedures

Language

English