Importing data into Excel
 

I wanted to know if Microsoft Excel can import a file into excel and then
automatically eliminate any duplicate records. For instance, File 1 and File
2 have multiple columns. Both share a common column header:

File 1
A B C D
Row 1 WRNO BN SALT MOLWt
Row 2 12345 A1 NONE 340.15
Row 3 23697 B1 NONE 540


File 2
Columns
A B C D E
Row 1 SMILES WRNO Para IC 50 IC 90
Row 2 C 12345 D6 286.36 552
Row 3 C 12345 W2 90 450
Row 4 C1C 23697 D6 NONE 540

I want to be able to automatically get rid of any duplicate cells and then
combine into File 1 all of the new rows to get the following data:

A B C D E F G
H I
Row 1 WR BN SALT MW SMILES D6 Ic 50 D6 IC 90 W2 Ic 50 W2
Ic 90
Row 2 12345 A1 NONE 340 C 286.36 552 90 450
Row 3 23697 B1 NONE 540 C1C NONE 540

How can I do this automatically? Is there a specific macro command/VB
script that I can use to obtain this output? I need for the script to
compare the data in File 1 against the data in file 2. If a column in FIle 2
is not in file 1, i want it to append that column and data to the file. If
there are duplicates within both files, I want the records to be deleted.
Thank you.

Ponder