Macro for comparing two worksheets and copying new data based on 2 column unique key?

how is the project is entered under project in both the sheets

from your text I presume
in workbook A project name and year entered in two different columns
e.g.

project year
a 2005
s 2006
d 2007
s 2008
a 2009


in workbooks B it is entered in the only column as
a<space>2005
a<space>2009

is this the configuration?????????????
better send a sample sheets in both workbooks.

Hello,

Thanks for your reply.
To answer your question, in both workbooks Project Number and Project Year are in different columns.
I've attached two example workbooks. The actual data contains more columns than what I have provided, but the relevant columns are included.

Basically what I need is a Macro that does this:

For each row in WorkbookA.ProjectList:
Look for a row in WorkbookB.Sheet1 that has the same Project Number and Project Name.
If there is no match
then copy the project number, project year and project title over from that row in WorkbookA.ProjectList and insert them into WorkbookB.Sheet1.

Thanks again!