Copy specific data from an excel template and paste in new workbook

E

excel_1317

Board Regular
Joined
Jun 28, 2010
Messages
212
I have around 100 excel templates in a folder from which I need to extract data from specific cells and put in a separate workbook. Is this something that can be done macro. The logic is MACRO open first template -> Copy Specific Cells -> Paste into new workbook-> Close template-> Proceed open with next template....

The cells(Summary sheet) which we need to copy are E5, D20, C43, D43, C85, D85, C87 and D87. Below is sample excel template.

Sheet2[TABLE="class: html-maker-worksheet"]
<thead>[TR]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[TH]C[/TH]
[TH]D[/TH]
[TH]E[/TH]
[TH]F[/TH]
[TH]G[/TH]
[TH]H[/TH]
[/TR]
</thead><tbody>[TR]
[TH]1[/TH]
[TD="align: center"]Output from Pricing Calculator v5.04[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]2[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]3[/TH]
[TD]The following pricing structure was produced on: [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]09 January 2013[/TD]
[TD][/TD]
[/TR]
[TR]
[TH]4[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]5[/TH]
[TD]Client Name:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]Sandvik Future[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]6[/TH]
[TD]Salesperson:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]Karin Kärvling-Söholt[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]7[/TH]
[TD]Sales Region:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]ROW[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]8[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]9[/TH]
[TD]Client Country:[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]Sweden[/TD]
[TD][/TD]
[TD][/TD]
[TD]Free Text Comments[/TD]
[TD][/TD]
[/TR]
[TR]
[TH]10[/TH]
[TD]Client Type:[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]Direct Corporate[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]11[/TH]
[TD]Number of end clients (if Agent):[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"] - [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]12[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]13[/TH]
[TD]Annual Renewal Breakdown:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]14[/TH]
[TD][/TD]
[TD="align: right"]USD - US[/TD]
[TD][/TD]
[TD="align: right"] 45 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]15[/TH]
[TD][/TD]
[TD="align: right"]USD - Non US[/TD]
[TD][/TD]
[TD="align: right"] 170 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]16[/TH]
[TD][/TD]
[TD="align: right"]GBP[/TD]
[TD][/TD]
[TD="align: right"] 340 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]17[/TH]
[TD][/TD]
[TD="align: right"]EUR[/TD]
[TD][/TD]
[TD="align: right"] 680 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]18[/TH]
[TD][/TD]
[TD="align: right"]Invoice Currency[/TD]
[TD][/TD]
[TD="align: right"] 340 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]19[/TH]
[TD][/TD]
[TD="align: right"]Other[/TD]
[TD][/TD]
[TD="align: right"] 1,020 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]20[/TH]
[TD][/TD]
[TD="align: right"]Total:[/TD]
[TD][/TD]
[TD="align: right"] 2,595 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]21[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]22[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]23[/TH]
[TD][/TD]
[TD][/TD]
[TD="align: center"]Standard Pricing[/TD]
[TD="bgcolor: #FFFF00, align: center"]Proposed Pricing[/TD]
[TD="align: center"]Variance[/TD]
[TD="align: center"]Existing Pricing[/TD]
[TD="align: center"]Variance[/TD]
[TD][/TD]
[/TR]
[TR]
[TH]24[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"](Prop. to Std.)[/TD]
[TD][/TD]
[TD="align: center"](Prop. to Existing.)[/TD]
[TD][/TD]
[/TR]
[TR]
[TH]25[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]26[/TH]
[TD]PER RENEWAL:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]27[/TH]
[TD][/TD]
[TD="align: right"]Client Currency:[/TD]
[TD="align: center"]SEK[/TD]
[TD="align: center"]SEK[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]28[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]29[/TH]
[TD][/TD]
[TD="align: right"]Fee Series:[/TD]
[TD="align: center"]8[/TD]
[TD="bgcolor: #FFFF00, align: center"]N[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]30[/TH]
[TD][/TD]
[TD="align: right"]Est. Currency Contribution (£):[/TD]
[TD="align: center"]79.18[/TD]
[TD="align: center"]68.26[/TD]
[TD="align: center"]-10.92[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]31[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]32[/TH]
[TD][/TD]
[TD="align: right"]Basic Service Charge Currency:[/TD]
[TD="align: center"]GBP[/TD]
[TD="align: center"]GBP[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]33[/TH]
[TD][/TD]
[TD="align: right"]Basic Service Charge (FX):[/TD]
[TD="align: center"]9.00 GBP - Code: 09[/TD]
[TD="align: center"]6.98 GBP - Code: N/A[/TD]
[TD="align: center"](£2.02)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]34[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]35[/TH]
[TD="align: center"]Pricing code will need review due to additional charges.[/TD]
[TD="align: right"]Invoicing:[/TD]
[TD="align: center"]Automatic / Quarterly[/TD]
[TD="align: center"]Automatic / Quarterly[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]36[/TH]
[TD][/TD]
[TD="align: right"](£):[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]37[/TH]
[TD][/TD]
[TD="align: right"]Credit terms:[/TD]
[TD="align: center"]30 Days[/TD]
[TD="align: center"]60 Days[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]38[/TH]
[TD][/TD]
[TD="align: right"](£):[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]4.02[/TD]
[TD="align: center"]4.02[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]39[/TH]
[TD][/TD]
[TD="align: right"]Receipts:[/TD]
[TD="align: center"]Store[/TD]
[TD="align: center"]Store[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]40[/TH]
[TD][/TD]
[TD="align: right"](£):[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]41[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]42[/TH]
[TD][/TD]
[TD="align: right"]Total Service Charge (£):[/TD]
[TD="align: center"]9.00[/TD]
[TD="align: center"]11.00[/TD]
[TD="align: center"]2.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]43[/TH]
[TD][/TD]
[TD="align: right"]Total Service Charge (Inv Curr):[/TD]
[TD="align: center"]99.19[/TD]
[TD="align: center"]121.28[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]44[/TH]
[TD][/TD]
[TD="align: right"]Total Service Charge (S/C Curr):[/TD]
[TD="align: center"]9.00 GBP - Code: 09[/TD]
[TD="bgcolor: #FFFF00, align: center"]11.00 GBP - Nearest Code: N/A[/TD]
[TD="align: center"]£2.00 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]45[/TH]
[TD][/TD]
[TD="align: right"]Reduced fees flag:[/TD]
[TD="align: center"]YES[/TD]
[TD="bgcolor: #FFFF00, align: center"]Yes[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]46[/TH]
[TD][/TD]
[TD="align: right"]Est. Country Fee (£):[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]47[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]48[/TH]
[TD][/TD]
[TD="align: right"]Commission arrangment:[/TD]
[TD="align: center"]NOT APPLICABLE[/TD]
[TD="align: center"]NOT APPLICABLE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]49[/TH]
[TD][/TD]
[TD="align: right"]Commission amount:[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]50[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]51[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]52[/TH]
[TD]ANNUAL ESTIMATE:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]53[/TH]
[TD][/TD]
[TD="align: right"]Client Currency:[/TD]
[TD="align: center"]SEK[/TD]
[TD="align: center"]SEK[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]54[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]55[/TH]
[TD][/TD]
[TD="align: right"]Fee Series:[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]N[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]56[/TH]
[TD][/TD]
[TD="align: right"]Est. Currency Contribution (£):[/TD]
[TD="align: center"]205,476.87[/TD]
[TD="align: center"]177,135.23[/TD]
[TD="align: center"]-28,341.64[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]57[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]58[/TH]
[TD][/TD]
[TD="align: right"]Basic Service Charge Currency:[/TD]
[TD="align: center"]GBP[/TD]
[TD="align: center"]GBP[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]59[/TH]
[TD][/TD]
[TD="align: right"]Basic Service Charge:[/TD]
[TD="align: center"]23,355.84[/TD]
[TD="align: center"]18,113.75[/TD]
[TD="align: center"](£5,242.09)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]60[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]61[/TH]
[TD="align: center"]Pricing code will need review due to additional charges.[/TD]
[TD="align: right"]Invoicing:[/TD]
[TD="align: center"]Automatic / Quarterly[/TD]
[TD="align: center"]Automatic / Quarterly[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]62[/TH]
[TD][/TD]
[TD][/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]63[/TH]
[TD][/TD]
[TD="align: right"]Credit terms:[/TD]
[TD="align: center"]30 Days[/TD]
[TD="align: center"]60 Days[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]64[/TH]
[TD][/TD]
[TD][/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]10,445.11[/TD]
[TD="align: center"]10,445.11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]65[/TH]
[TD][/TD]
[TD="align: right"]Receipts:[/TD]
[TD="align: center"]Store[/TD]
[TD="align: center"]Store[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]66[/TH]
[TD][/TD]
[TD][/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]67[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]68[/TH]
[TD][/TD]
[TD="align: right"]Total Service Charge (£):[/TD]
[TD="align: center"]23,355.84[/TD]
[TD="align: center"]28,558.86[/TD]
[TD="align: center"]5,203.02[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]69[/TH]
[TD][/TD]
[TD="align: right"]Total Service Charge (Inv Curr):[/TD]
[TD="align: center"]257,399.99[/TD]
[TD="align: center"]314,741.47[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]70[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]71[/TH]
[TD][/TD]
[TD="align: right"]Reduced fees flag:[/TD]
[TD="align: center"]YES[/TD]
[TD="align: center"]Yes[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]72[/TH]
[TD][/TD]
[TD="align: right"]Est. Country Fee (£):[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]73[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]74[/TH]
[TD][/TD]
[TD="align: right"]Commission arrangment:[/TD]
[TD="align: center"]NOT APPLICABLE[/TD]
[TD="align: center"]NOT APPLICABLE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]75[/TH]
[TD][/TD]
[TD="align: right"]Commission amount (£):[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]76[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]77[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]78[/TH]
[TD]Estimated Disbursements (£):[/TD]
[TD][/TD]
[TD="align: center"]801,353.78[/TD]
[TD="align: center"]801,353.78[/TD]
[TD="align: center"]0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]79[/TH]
[TD]Estimated Disbursements (Inv Curr):[/TD]
[TD][/TD]
[TD="align: center"]8,831,559.76[/TD]
[TD="align: center"]8,831,559.76[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]80[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]81[/TH]
[TD]Estimated Turnover (£):[/TD]
[TD][/TD]
[TD="align: center"]1,050,241.18[/TD]
[TD="align: center"]1,027,102.57[/TD]
[TD="align: center"]-23,138.61[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]82[/TH]
[TD]Estimated Turnover (Inv Curr):[/TD]
[TD][/TD]
[TD="align: center"]11,574,497.99[/TD]
[TD="align: center"]11,319,491.95[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]83[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]84[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]85[/TH]
[TD]Estimated Gross Income (£):[/TD]
[TD][/TD]
[TD="align: center"]248,887.40[/TD]
[TD="align: center"]225,748.78[/TD]
[TD="align: center"]-23,138.61[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]86[/TH]
[TD]Estimated Gross Income (Inv Curr):[/TD]
[TD][/TD]
[TD="align: center"]2,742,938.22[/TD]
[TD="align: center"]2,487,932.19[/TD]
[TD="align: center"]-255,006.03[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]87[/TH]
[TD]Gross Income/case (£)[/TD]
[TD][/TD]
[TD="align: center"]95.91[/TD]
[TD="align: center"]86.99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Excel 2010





Desired result is shown in table below.
Sheet1[TABLE="class: html-maker-worksheet"]
<thead>[TR]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[TH]C[/TH]
[TH]D[/TH]
[TH]E[/TH]
[TH]F[/TH]
[TH]G[/TH]
[TH]H[/TH]
[/TR]
</thead><tbody>[TR]
[TH]1[/TH]
[TD]Client Name [/TD]
[TD]Volume[/TD]
[TD]Total Service Charge(Standard Pricing)[/TD]
[TD]Total Service Charge(Proposed Pricing)[/TD]
[TD]Estimated GI(Standard Pricing)[/TD]
[TD]Estimated GI(Proposed Pricing)[/TD]
[TD]GI per case(Standard Pricing)[/TD]
[TD]GI per case(Proposed Pricing)[/TD]
[/TR]
[TR]
[TH]2[/TH]
[TD]KTS[/TD]
[TD="align: right"]400[/TD]
[TD="align: center"]109.09[/TD]
[TD="align: center"]121.21[/TD]
[TD="align: center"]1,433,934.54[/TD]
[TD="align: center"]1,492,558.60[/TD]
[TD="align: center"]296.48[/TD]
[TD="align: center"]308.6[/TD]
[/TR]
[TR]
[TH]3[/TH]
[TD]Microsoft[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Excel 2010
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

R
  • Question Question
vlookup help
Replies
0
Views
1K
Roosterfosho
R

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top