(Solved) – VBA Reformate Sheet to Look like another Sheet Then Compare


So I have a bunch of payroll working time data at “Sheet1” (work hours) that was collected from id card access system and i want to compare it with the data i gathered from the employees by google forms “Sheet2”, but the problem is the two sheets are very different from each other and because of that i need to reformate (transpose?) the forms data to look like the other.

So I need to reformat “Sheet2” to look like “Sheet1” and then compare them and highlight the unequal rows

In the real workbook there are 450 employee data for 31 days.

I started using VBA few months ago so i don’t have to much experiance.

Can somebody help me with this please? 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *