Automatically Combining Records from 2 Files into one data base

[Mark Delman]

I want to combine two files to create one data base and am wondering if there is a way to do so quickly.

Specifically, I have customer sales data from my web site that contains order numbers and sales data. From Google analytics, I have transaction information that also contains the order number. The data element that is common to both is order number. I can't just paste columns from one file into the other because the records listed in rows may not match up.

I don't want to have to copy and paste data from one file to another for each record manually since I have thousands of records. Is there a way to merge the two files together automatically by having Excel "understand" that it should pair the two files together using the order number to create a row that contains data from both files?

Thanks.

-Mark

[xladept]

You could use an User Defined Type (Data Structure - UDF) and gather the fields from each file to create the combined record.