Excel macros are killing me!

[brogi_bear]

Hi all... newbie here

I have been tasked to create a macro for HR regarding insurance bills in which i have to compare two different files- and they are not formatted the same (for example one has department codes, the other doesn't and has items in different rows and columns.) What both documents have in common though are names (first & last), the type of Premium (insurance plan type) and the total of that premium per person such as: Joe Dirt | $107.07 | Dental Plan. Although it would be ideal to replicate the dept code from one to another i can't figure how i can do that from different files. The end goal is to highlight the differences between both files and highlight in green if it matches, yellow if it doesn't match, and red if there is missing info. Does anyone know how i can achieve the end goal? or where i can start, as i cant find a formula that can meet these demands, i am starting to think it is impossible.

thanks!! I appreciate any insight and pointers!

 

[mumps]

The macro will work with any name. The macro first checks to see if the name in List Bill exists in downloadbill. If it doesn't exist, it skips to the next name without coloring any cells because it has no data to compare in downloadbill since that name doesn't exist in that sheet. Does this make sense?

 

[brogi_bear]

Yes sorry, i found why it was doing that! i appreciate the help a lot and thanks for the material you shared!

 

[mumps]

My pleasure.