to retrieve a particular value from excel sheet

R

refina

PAYMENT RECEIPT BALANCE
Branch pune 0.00 4,153,150.00

01/07/2007 1 6,899,650.00
01/07/2007 2 17,308,800.00
01/07/2007 3 17,308,800.00
BranchTotal 24,218,450.00 24,208,450.00 28,351,600.00

Branch kolkatta 0.00 4,153,150.00
03/07/2007 4 110,000.00
03/07/2007 5 85,000.00
03/07/2007 6 58,200.00
03/07/2007 7 283,750.00
03/07/2007 8 324,000.00
BranchTotal 24,218,450.00 24,208,450.00 4,143,150.00




For the above sheet i should
1.get the balance 4,143,150.00 of branch total of kolkatta.
2.copy and save tat value in another excel sheet.


Please reply
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reverse Index Match 2
Eliminate repeat values in one field 7
Sum value between two dates and copy to new cell 7
HELP! MORTGAGE SCHEDULE WITH EXTRA PMTS EVERY 4 MONTHS 3
Excel formula 2
INDEX or VLOOKUP function 0
Exporting data to Excel from VB6/VBA 1
IF ARRAY with multiple conditions. 1

Top