Compare two sheets

Please see the attached 2 spread sheets.

1. Problem - Temp.XLS
2. What I am expecting after automation - Solution Temp

There are two work sheets in my TEMP.XLS. One is before and one is after. The key for both the sheets is CASE & INSATNCE, Col1 and Col2.

First Requirement:

I want to bring the row from 'Before' sheet to 'AFTER' Sheet if the Key is matching. The Brought over row should be just be after the matching row. Which means in the 'after' sheet, the second row would be the after values and the third row would be the before values if the key is matched.

Second requirement is to highlight the brougt over row. (Please see the highlighted row in yellow in solution temp spread sheet in "After" sheet)

Third requirement is to compare the values againt COL1 to COL 60 between the two rows of the same key. If they don't match write "FAil" in the column BK. (Please see the column BK in 'solution temp.xls' spread sheet in "After" sheet)

Fourth Requiremrnt is to count the
Values between COL1 and COl60 for all the rows. However, some of the columns has two characters and some has three characters. we need to count them seperately and place the result in two columns. Please see columns BL and BM. BL is for two characters and BM is for three characters.

Can this be done ? Your help is really appreciated.