Macro Needed To Compare two list and copy data to another Sheet

[anappleuser]

Hi Guys,

I need a macro which can do following thing.

Sheet1

Sheet2

Results in Sheet3

Column A

Column B

Column C

Column D

Column E

Column A

Column A

Column B

Column C

Column D

Column E

AA

X

X

X

X

AA

AA

X

X

X

X

AA

X

X

X

X

YY

AA

X

X

X

X

CC

X

X

X

X

XX

DD

X

X

X

X

DD

X

X

X

X

DD

DD

x

x

x

x

DD

x

x

x

x

FF

DD

x

x

x

x

DD

x

x

x

x

PP

1. Match names available in Sheet2 with Sheet1 values available in Coloumn A

2. For each sheet2 name matching with name in sheet1 than copy those all matching rows from sheet 1 to sheet 3

<colgroup><col span="17"></colgroup><tbody>
</tbody>

There are around 20000 values in sheet1. and sheet2 will have values around 2000. So how can i do this thing using macro.

Please Help.

Thanks