Hi all, I have this working excel file (lets name it abc). I have few more files say minimum 4 workbooks and maximum 275 workbooks (bank statements in excel format) (all stored in a single folder).
Now what I want is I need to get an amount which is located in the source workbooks and copy the same in the abc excel file.
For example in in the abc file contains 301 rows of schools with unique id code (the same unique id code is available in other workbooks too.
In the abc file in column c2 i need to get bank interest amount which is located in the bank statement. Bank interest will be two times each identified with a different string like Int. Pd: 010315 to 310815 (1st part) and Int. Pd: 010915 to 290216 (2nd part). F6 contains Int. Pd: 010315 to 310815 and G6 contains 1402.50 (amount), similary F8 contains Int. Pd: 010915 to 290216 and G8 contains (3056.50) amount.
Now I want these amounts to be copied in the abc file at a particular cell say C2.
Can any one please help me.
[TABLE="width: 160"]
<tbody>[TR]
[TD="class: xl63, width: 160"][/TD]
[/TR]
</tbody>[/TABLE]
Now what I want is I need to get an amount which is located in the source workbooks and copy the same in the abc excel file.
For example in in the abc file contains 301 rows of schools with unique id code (the same unique id code is available in other workbooks too.
In the abc file in column c2 i need to get bank interest amount which is located in the bank statement. Bank interest will be two times each identified with a different string like Int. Pd: 010315 to 310815 (1st part) and Int. Pd: 010915 to 290216 (2nd part). F6 contains Int. Pd: 010315 to 310815 and G6 contains 1402.50 (amount), similary F8 contains Int. Pd: 010915 to 290216 and G8 contains (3056.50) amount.
Now I want these amounts to be copied in the abc file at a particular cell say C2.
Can any one please help me.
[TABLE="width: 160"]
<tbody>[TR]
[TD="class: xl63, width: 160"][/TD]
[/TR]
</tbody>[/TABLE]
