Copy data to another workbook and auto fill

Closed
kobi077 Posts 1 Registration date Saturday June 1, 2013 Status Member Last seen June 1, 2013 - Jun 1, 2013 at 05:33 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 1, 2013 at 06:08 PM
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
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 1, 2013 at 06:08 PM
you can use lookup.
0