EXCEL FIND UNIQUE ID RECORDS & COPY

Hello,



I need help to compare 2 sheets & copy the unique records in sheet 3. I give below the following details for your valuable instructions:

Sheet1(Master) : (Total records more than 10000 Nos)
Column A: Cust_Id, Column B: Cust_Name, Column C: Cust_Place, Column D: Credit Limit

Sheet2(Details): (Total records below 4000 nos)
Column A: Cust_id, Column B: Cust_Name, Column C: Cust_Place, Column D: Sales, Column E: Month

I need to help compare sheet2 with Sheet1 and copy the unique customer details to sheet3.
Sheet3(Compare) (Details required)
Column A: Cust_id, Column B: Cust_Name, Column C: Cust_Place, Column D: Sales, Column E: Month, Column F: Credit Limit (from sheet1)

Sheet 4(Missing records) (Details required)
Column A: Cust_id, Column B: Cust_Name, Column C: Cust_Place, Column D: Sales, Column E: Month, Column F: Credit Limit (from sheet1)

Please help me & inform vb script or macros. Also please send a sample file to Deleted@yahoo.co.in
Thanks in advance
CSGdows XP / Safari 536.11</config>