Check for existing data

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!

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
>
>

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
>
>

Hi Kevin,

The search function has to be performed with a macro. I don't know if it is possible to use VLookUp in a macro. Else do you know another solution for using a macro? Thanks in advance!