Copy data to another workbook and auto fill

Closed
Report
Posts
1
Registration date
Saturday June 1, 2013
Status
Member
Last seen
June 1, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
First,
I Have excel data base that he have information in 3 Column A(id numbers),B(First Name),C(last Name).
I have another Excel workbook that in B Column I Fill the Id numbers,
and i want that when i put the id Numbers in Column B, in the same line
Automatically filled in C(First Name), and in D(last Name).

who can i do that?
Thx

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you can use lookup.