This reviews all the records in a MASTER list and verifies their existence in a SLAVE list. The missing records and their associated key values are listed out.

The user form contains the following fields and buttons

Master/Slave	Field Name	Description	Button	Purpose
Both	Worksheet Name	The name on the worksheet tab; like 'Sheet1'	Select	Verifies that the sheet exists and identifies an appriopriate data list
Both	List Range	Shows the range address of the first datalist on the worksheet	Accept	You must confirm that this the list range you want to analyse
Both	Coumn	A drop dowm list of all the column letters within the used range of the worksheet	Re-evaluate	To be use in conjuction with 'Row' - resets the List Range to the data list that surrounds the selected cell
Both	Row	A drop dowm list of all the row numbers within the used range of the worksheet	Re-evaluate	To be use in conjuction with 'Column' - resets the List Range to the data list that surrounds the selected cell
Both	Key Field	A drop down list of all the Column Headings for the selected data list	Validate	Verifies that the field selected does not contain any duplicate values
Master only	Report Value Column	A drop down list of all the Column Headings for the selected data list

One feature of using this form is that you must complete the the fields in order. The form itself highlights where you are in the process by by enabling the button associated with the next field to be completed. The buttons are enabled in the following order

• Select (the worksheet)
  
• Accept (the data list range) and Re-evaluate (the data list range) together
  
• Validate (the key field)
  

You cannot proceed with the comparison until all the buttons associated with both the MASTER and SLAVE lists have been processed (i.e. they are all shaded out as disabled).

The report of the missing records is posted to a new worksheet in the active workbook. It takes the following form.

See also

List Comparison