I am trying to create an excel (2007) macro (in windows XP) 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.
Compare
Clear
(on sheet 1) columns 1,2,3 & 4 would be prepopulated (via a copy and paste method), 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.
Example.
ID Number
first name
last name
job type code
qualified
1234
Bill
Smith
BLK
Compare
5678
John
Citizen
REV
1000
Paul
Person
MIF
Clear
(on sheet 1) columns 1,2,3 & 4 would be prepopulated (via a copy and paste method), 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.
