Excel vba, data comparison between two workbook
Budget: ₹600 – ₹1,500 INR
Book 1: we will have a table with Student name, sub1, sub2, total, percentage, pass/fail
Book 2: roll no., Student name, it will also have two columns pass/fail and total but that pass/fail and total data we have to get from book1 as the students name in book2 will have some similar name as in book1 also the names in book1 might be in this order (lastname, firstname) but the names in book2 are in order firstname, lastname. This all will be done via a macro present in book2.
Also there might be some extra names in book2 which are not present in book1 so for that case in pass/fail column we have to update as missing record.
And then we have to send book1, book2 and the missing data table that has to be shared in the mail.
Please see the attached pics for the steps and instructions.
Book 2: roll no., Student name, it will also have two columns pass/fail and total but that pass/fail and total data we have to get from book1 as the students name in book2 will have some similar name as in book1 also the names in book1 might be in this order (lastname, firstname) but the names in book2 are in order firstname, lastname. This all will be done via a macro present in book2.
Also there might be some extra names in book2 which are not present in book1 so for that case in pass/fail column we have to update as missing record.
And then we have to send book1, book2 and the missing data table that has to be shared in the mail.
Please see the attached pics for the steps and instructions.