I am trying to create an excel (2007) macro which will compare a list of data on 1 worksheet with that on another worksheet within the same workbook and then have an out put in the first spread sheet.

Example.

ID Number first name last name job type code qualified
1234 Bill Smith BLK Compare button
5678 John Citizen REV
1000 Paul Person MIF Clear button

(on sheet 1) columns 1 (ID),2 (first name),3(last name) & 4(job type code) would be prepopulated, an action button "Compare" would be used, this would then compare the data in the "Job type code" fields with the "qualifications" listings from a range that would be listed on worksheet 2 of the same workbook. Example see below

BLK Qualifications
Certificate of economics
Certificate of accounting


REV Qualifications
Certificate of leisure
Certificate of Hope



MIF Qualifications
Certificate of Sports medicine
Certificate of quackery
Certificate of pet care

The final Output being "Yes" or "No" to then be displayed in the "Qualified" column on worksheet 1 and finally a "clear" action button to clear the data from the "Qualified" column when the final outcome has been complete.

Hope someone can assist me