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!

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!

Yes, there will be common fields, such as Item Code and Product Description.
And yes, typically, the received format will be Excel. The part I am unsure
about is how to automate the comparison.

"Jim Thomlinson" wrote:

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!

I've had to do something very similar. I ended up declaring a couple of
variant arrays and then populated each with their respective data. I could
then very easily determine equality (plus I could put the formatted data
elswhere for inspection).

"Tina" wrote in message
...
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!