Is there some unique field upon which the data from the two vendors can be
joined? Even if that data is in different formats that is where we need to
start. Otherwise how do you plan on making the comparison. And define
different formats. Does the data come in Excel format or is it in text files
or???


"Tina" wrote:

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!