HI ALL ,
I AM HAVING A WORKSHEET ( SHEET 1) WITH THE FOLLOWING DATA

ACC1 , CUS ID , NAME , ADD 1 ,ADD2 ,ADD3 ,ADD4 ,ADD5 ,PIN, PHONE

ANOTHER WORK SHEET ( SHEET 2) WITH

ACC2

THE REQUIRMENT IS THAT THE DATA IN THIRD SHEET SHOULD BE THE MERG OF SHEET 2 AND SHEET1 ,
LIKE SHEET 1 HAS THE WHOLE DATABASE MAYBE 32000 RECORDS
SHEET 2 HAS SOME 200 RECORDS WHICH HAS TO BE SEARCHED AND COPIED IN THE SHEET 3 IN THE FOLLWOING FORMAT

ACC2 , CUS ID ,NAME , ADD 1 ,ADD2 ,ADD3 ,ADD4 ,ADD5 ,PIN, PHONE

pLEASE HELP ME OUT IN DOING THIS