Add new data from another workbook in excel vba

[Closed]
Report
Posts
1
Registration date
Friday March 27, 2015
Status
Member
Last seen
March 27, 2015
-
Hi All,

I have a problem with excel vba as below that need your help:

I have 2 workbook (wb1, wb2). What I want is to loop through data in collum "A" of wb1 and through data in collum "A" of wb2. Any data in wb2 that not found in wb 1 will be added at the end of the data range in wb1.

Thank you so much