Hi.

Imagine, we have 2 excel files file1 and file2 . In file1, there is one column with name User_ID and some cells in this column are filled with numbers; Let it be "A" column and as I said, A2, A3, A4 and so far are filled with numbers (In the A1 cell is written Name of column, in this case User_ID). The Next B column is named , for example, User_Name and B2 , B3, B4 cells and so far are filled with some texts, let them be John, Ann, Kate and etc ( In the B1 cell is written User_Name ).

In file2, we have also "A" column with name User_ID (in A1 cell is wirtten "User_ID") and as in file1, A2, A3, A4 and other cells of this column are filled with the same numbers, as in file1 . But in this case, in file2 we don't have the second column filled with User_Names.

I want to make Macro in file2, which will do following: Take rows from file1, where the User_ID of file2 and file1 are same and make "B" column filled with texts (User_Names) relevant to User_IDs.

Is it possible?

Or if it's impossible to do with Macros, could you say how can I do this?

Thanks In Advance.