Compare two workbooks and Copy missing data
 

Hi all,

I have two workbooks, both contain the same information,like jobid, status,
customer name and date, but with minor differences.I would like to exract
the missing information from both workbooks to a totally new workbook. The
two work books may contain up to 1000 records at a time. Is there an easier
way like a macro would be good. HELP

The two workbooks may look something like this;

WORKBOOK 1
A B C D
1001 Finish John 30-jan-06
1002 Traction Many 21-dec-05
1003 Finish Joe 05-jan-06

WORKBOOK 2
A B C D
1001 Finish John 30-jan-06
1002 Traction Many 21-dec-05

I would like the new workbook to show;

WORKBOOK 3
A B C D
1003 Finish Joe 05-jan-06

Please help......