I would like to combine two sheets into a new sheet, like this:

file1, sheet 1:
        a        b        c
1    abc    blabla    10
2.   klm    blabla    45
3.   xyz    blabla     25

file2, sheet1:

        a
1    abc
2.    xyz

The new file should look like this:

new file, sheet 1:
        a        b        c
1    abc    blabla    10
2.   xyz    blabla     25

I want to copy al the values from file 2, to the new file and if a value in
file1, sheet 1, column a also exists in file2, sheet 1, column a , I want to
copy column b, c, d and so on to the new file, after the value that exist in
both files.

I hope that someone can help me with this, it is very much appreciated.

T.i.a.,
Walter de Kok

Then in column b put in a formula like (B1 in the example)

=Vlookup(A1,[file1.xls]Sheet1!$A$1:$C$2000,2,False)
in C1
=Vlookup(A1,[file1.xls]Sheet1!$A$1:$C$2000,3,False)

Then drag fill these down the column

Select Columns B and C, do Edit=>Copy, then Edit=>Paste and Select Values to
change the formulas to be the results they display.

Regards,
Tom Ogilvy