excel help

[danzigrules]

Hi,

I know nothing about excel, but I think it can do what I need. Any help is appreciated.

I need to merge 2 excel files and not have duplicates in the merged file. It also needs to add anything that is missing from file 1, from file 2.

There are around 120-150 lines and at least 10 columns if not more.

Example: file 1

col 1 col 2 col 3
I29 12345 10-25-07
I52 10-9-07

File 2:

I29 12345
I52 67890 10-9-07


Even if I have to make a new File, that works for me, I just need to make sure there are no duplicates and if any info is missing in file 1 or file 2 it gets added.
Is this even possible?


Thanks

 

[dderolph]

Open Excel's Help and do a search on merge workbooks. It explains a procedure.