Hi leonidas,

Your best oiption is to use a VLOOKUP, this way you can see what's on and
what isn't on your 2nd workbook. Have a look at the help for VLOOKUP, this
will get you started.

HTH
KM

"leonidas" wrote:

>
> Hi,
>
> I have 2 worksheets with a lot of data in column B. The second
> worksheet is a copy of the first worksheet and is necessary to see the
> difference between the 2 worksheets. On the second worksheet an other
> user can add rows and insert new data in column B.
> Afterwards a résumé should be made on a new worksheet. Therefore column
> B from the first worksheet is being copied to this new worksheet.
> Now the tricky part.
> A check should be made if the data in column B from the second
> worksheet also exists on the new résumé worksheet. If not, then it
> should be copied to the new résumé worksheet at the same place as it is
> on the second worksheet.
> I only don't know how to do this. Can someone help me? Thanks in
> advance!
>
>
> --
> leonidas
> ------------------------------------------------------------------------
> leonidas's Profile: http://www.excelforum.com/member.php...o&userid=35375
> View this thread: http://www.excelforum.com/showthread...hreadid=567807
>
>