I need a macro to compare to worksheets (eg., Sheet1 and sheet2), such that the missing values should be copied into the new sheet (sheet3).

Note: the two input sheets( sheet1 and sheet2) has data in the below formate.

The compare should be Sheet2 with sheet1 (becoz sheet1 data is the master data)

Sheet1:

Column Column
A ..... . B
------- --------
AAAAA ..... . 3------------> This value 3 represents the value of coulmn A ("AAAAA") has 3 occurcance
BBBBBB ..... . 4 ------------> This value 4 represents the value of coulmn A ("BBBBBB") has 3 occurcance
CCCCC ..... . 2 -----------> similarly
EEEEEE ..... . 1 -----------> " "
WWWW ..... . 3 ----------> " "


(i.e) the above sheet1 represents has mentioned below
Column
A
AAAAA
AAAAA
AAAAA
BBBBBB
BBBBBB
BBBBBB
BBBBBB
CCCCC
""

Sheet2:

Column
A
--------
AAAAA
AAAAA
BBBBBB
CCCCC
EEEEEE
WWWW


So after comparing both sheet1 and sheet2 with above data, the results should be has mentioned below:


Sheet3 should be:
The compare should be Sheet2 with sheet1 (becoz sheet1 data is the master data)

Column
A
--------
AAAAA
BBBBBB
BBBBBB
BBBBBB
CCCCC
WWWW
WWWW

incase if some of the value in sheet2 is not present in sheet1 then these data should be copied in sheet4.

Please Some one wirte the macro code to result the above functionalities.

Thanks in Advance