can't you just copy the whole column and paste it in the other work book? To scroll to the bottom you can click on the first cell and then press control shift down arrow. Copy and paste are in the edit drop window.
No cause the work books contain other info that needs to staty the same. the info is sorted diffrent in one book and diffrent on the other, yet i would like to locate the same such all the names in a A1:A3000 and if found move the date of birth and copy it in a in A2:3000 only if the name is found, similar but the the same.
It can be easily done by using Vlookup or index/match .... it depends how the data you have ...... can you be more specific by giving exactly the column of work book 1 and 2 and explain which column you want to match ..... Try to write column heading using code<> button in reply window ...
Column A - namesColumn B - Accts # Column C- DOBColumn D- Balance
Column A - namesColumn B - Accts # Column C- Balance Column D- Adjustments Column E- tel #
First of all thank you for your help,
Both work books have similar information, I want to create only one but by moving the information to work book 1.
I want to move Column D and Column E from work book 2 to work book 1. by matching the Column B on both work books. Once the account # is located the adj and the tel information need to be move to column E and F.
if you have the same arrangement of columns in work books and also in sheet1 then use below formula
E2=INDEX([Book2.xls]Sheet1!$D:$D,MATCH(A2,[Book2.xls]Sheet1!$A:$A,0)) for adjustment from book 2
F2=INDEX([Book2.xls]Sheet1!$E:$E,MATCH(A2,[Book2.xls]Sheet1!$A:$A,0)) for tel # from book 2
Both work well but i preferred to use index/match ....
But one thing keep in your mind that names should be unique as if there will be same name then first name entry will always come from book2 .... hope there will be less equal name peoples there. but if there are then you can give them name- and name-2 in both work books ....