What should i do when i have to work in two Excel File and there are
many Account no in Workbook 1 and book 2 contains many account no and
there amount now i have to take Account no. from book 1 one by one and
come to the book 2 to search there availability and paste there amount
in book 1.

i.e.

Book 1 contains a column

Account No.
0004317575603512196
0004006676010767385
0004317575603323636
0004317575603277113
0004317575603539660.


Account No. Amount
0004317575603631103 20
0004317575603578569 913
0004317575603097701 712
0004317575603512196 50
0004006661130015717 726
0004006676010767385 10000
0004317575603548794 500
0004317575603323636 200
0004006661030774793 500
0004317575603277113 20
0004317575603539660 21


Is there any way that we can paste all 5 Account No's amount to the
front of Account Nos in Book 1

Thanks in advance


--
dalipsinghbisht
------------------------------------------------------------------------
dalipsinghbisht's Profile: http://www.excelforum.com/member.php...o&userid=32557
View this thread: http://www.excelforum.com/showthread...hreadid=524696