View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
refina refina is offline
external usenet poster
 
Posts: 6
Default to retrieve a particular value from excel sheet

Please reply within tomarrow
refina wrote:
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