comparing two excel sheets in QTP

[kodhanrajesh]

Hi

Please help me to compare below both spreadsheets as mentioned in the below and attached the both of the spreadsheets.
Source A+B=Target J
Source C= Target G
Source D= Target E
Source I = Target M
Please help me out. Thank in Advance!!.

Source file
A, B, C, D, E, F, G, H, I
2011, Jan, Loans due from /to Gp ops, Aviva I Total (G014), None, None, None, Plan 2011-2013 V3, 101760000
2012, Apr, Loans due from /to Gp ops, Total Non-Insurance, None, None, None, Plan 2011-2013 V3, 244967233.4
2012 Apr Investment in Gp ops Total Non-Insurance None None None Plan 2011-2013 V3 -1.352
2012 Apr Ordinary Share Capital Total Non-Insurance None None None Plan 2011-2013 V3 -73832207.78
2012 Apr Share premium Total Non-Insurance None None None Plan 2011-2013 V3 -124861191.3
2012 Apr Currency translation reserve Total Non-Insurance None None None Plan 2011-2013 V3 79556.192


Target file
A, B, C, D, E, F, G, H, I, J, K, L, M
PLAN, 2010, Dec, YTD, NI_TM1_IVOT, GBP, Goodwill cost reserve, [ICP None], [None], 2011_Feb, [None], [None], -713360000
PLAN, 2010, Dec, YTD, NI_TM1_IVOT, GBP, Goodwill cost reserve, [ICP None], [None], 2011_Apr, [None], [None], -713360000
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Property and equipment [ICP None] [None] 2011_Apr [None] [None] 30561912.65
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Loans [ICP None] [None] 2011_Apr [None] [None] 9360000
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Rec and other fin assets [ICP None] [None] 2011_Apr [None] [None] 92387363.09
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Int bearing borrowings [ICP None] [None] 2011_Apr [None] [None] -7387981.6
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Pension obligations and other prov [ICP None] [None] 2011_Apr [None] [None] -289751282.9
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Net tax asset_liability [ICP None] [None] 2011_Apr [None] [None] -19606548.3
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Bank overdraft [ICP None] [None] 2011_Apr [None] [None] -141556.84
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Payables out of RI ops [ICP None] [None] 2011_Apr [None] [None] 6698946.539
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Other Liabilities Other [ICP None] [None] 2011_Apr [None] [None] -104714830.3
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Goodwill [ICP None] [None] 2011_Apr [None] [None] 713360000
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Other indefinite intangibles [ICP None] [None] 2011_Apr [None] [None] 12400000
PLAN 2010 Dec YTD NI_TM1_IVOT GBP NI Profit [ICP None] Non Prop Non Life Reinsurance_Casualty 2011_Apr Personal Motor Ops and Non Core 1631759.161
PLAN 2010 Dec YTD NI_TM1_IVOT GBP NI Profit [ICP None] Proportional Non Life reinsurance 2011_Apr Personal Motor Strategic Partnerships -49142.24157
PLAN 2010 Dec YTD NI_TM1_IVOT GBP NI Profit [ICP None] Proportional Non Life reinsurance 2011_Apr Homeowner RAC Insurance Aviva Underwritten 80900.72001