I've been tasked to design a spreadsheet that compares 2 or more sets of
data. Each set is delivered by a different vendor, therefore have different
formatting. The main goal is to automate the comparison of the data. Has
anyone dealt with this type of issue before? I'm thinking VB is the best way
to go, but am not sure.

thanks!