macro to transfer data from one file to another

I'm new to vba programming and was trying to make a pc of code using bits of info from the net, but it isn't working. pls some one help me write it.

problem:
i have two files a.xls and b.xls . in a.xls (sheet 1) there is a column(column A) with names of people. And in b.xls(sheet 1) in column A there is a longer list of names and in column B their phone nos. i want to write a vba code to take each name in a.xls and find it in b.xls and take the phone no. from b.xls and write it into the first file.

this is the code iv written, you may correct it or write ur own:

Please Login or Register  to view this content.

You don't need VBA, VLOOKUP will do that

This formula in Book2 will lookup the value in B1 in a table in Book1

=VLOOKUP(B1,[Book1]Sheet1!$A$1:$B$4,2,FALSE)

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save