Ex. i want to pull the information from cell A where it shows total for account into column B and that set of information end where it shows total for account and the next cell pick up with the next round of information.
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL></COLGROUP>
| ACCOUNT</SPAN> | Acct Id</SPAN> | BASE CHARGES</SPAN> | DISCOUNT/CREDIT</SPAN> | surcharges</SPAN> | GOV'T TAX & FEES</SPAN> | TOTAL CHARGES</SPAN> |
| 123456789</SPAN> | $115.00</SPAN> | $0.00</SPAN> | $5.52</SPAN> | $1.83</SPAN> | $122.35</SPAN> | |
| TOTAL FOR ACCOUNT # 123456789</SPAN> | 123456789</SPAN> | $115.00</SPAN> | $0.00</SPAN> | $5.52</SPAN> | $1.83</SPAN> | $122.35</SPAN> |
| 234567890</SPAN> | $200.00</SPAN> | $0.00</SPAN> | $9.47</SPAN> | $0.00</SPAN> | $209.47</SPAN> | |
| 234567890</SPAN> | $300.00</SPAN> | $0.00</SPAN> | $28.18</SPAN> | $0.00</SPAN> | $328.18</SPAN> | |
| 234567890</SPAN> | $250.00</SPAN> | $0.00</SPAN> | $0.00</SPAN> | $0.00</SPAN> | $250.00</SPAN> | |
| 234567890</SPAN> | $30.00</SPAN> | $0.00</SPAN> | $0.00</SPAN> | $0.00</SPAN> | $30.00</SPAN> | |
| TOTAL FOR ACCOUNT # 234567890</SPAN> | 234567890</SPAN> | $780.00</SPAN> | $0.00</SPAN> | $37.65</SPAN> | $0.00</SPAN> | $817.65</SPAN> |
| $100.00</SPAN> | $0.00</SPAN> | $9.47</SPAN> | $0.00</SPAN> | $109.47</SPAN> | ||
| $500.00</SPAN> | $0.00</SPAN> | $28.18</SPAN> | $31.85</SPAN> | $560.03</SPAN> | ||
| $70.00</SPAN> | $0.00</SPAN> | $0.00</SPAN> | $3.78</SPAN> | $73.78</SPAN> | ||
| $15.00</SPAN> | $0.00</SPAN> | $0.00</SPAN> | $1.04</SPAN> | $16.04</SPAN> | ||
| TOTAL FOR ACCOUNT # 345678901</SPAN> | $585.00</SPAN> | $0.00</SPAN> | $37.65</SPAN> | $36.67</SPAN> | $659.32</SPAN> | |
| $150.00</SPAN> | $0.00</SPAN> | $28.18</SPAN> | $27.79</SPAN> | $205.97</SPAN> | ||
| $55.00</SPAN> | $0.00</SPAN> | $0.00</SPAN> | $3.15</SPAN> | $58.15</SPAN> | ||
| TOTAL FOR ACCOUNT # 456789012</SPAN> | $205.00</SPAN> | $0.00</SPAN> | $28.18</SPAN> | $30.94</SPAN> | $264.12</SPAN> | |
| $250.00</SPAN> | $0.00</SPAN> | $9.47</SPAN> | $0.00</SPAN> | $259.47</SPAN> | ||
| $350.00</SPAN> | $0.00</SPAN> | $28.18</SPAN> | $27.79</SPAN> | $405.97</SPAN> | ||
| TOTAL FOR ACCOUNT # 567890123</SPAN> | $700.00</SPAN> | $0.00</SPAN> | $37.65</SPAN> | $27.79</SPAN> | $765.44</SPAN> | |
| $500.00</SPAN> | $0.00</SPAN> | $28.18</SPAN> | $0.00</SPAN> | $528.18</SPAN> | ||
| $100.00</SPAN> | $0.00</SPAN> | $4.74</SPAN> | $0.00</SPAN> | $104.74</SPAN> | ||
| $55.00</SPAN> | $0.00</SPAN> | $0.00</SPAN> | $3.68</SPAN> | $58.68</SPAN> | ||
| TOTAL FOR ACCOUNT # 678901234</SPAN> | $655.00</SPAN> | $0.00</SPAN> | $32.92</SPAN> | $3.68</SPAN> | $691.60</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL></COLGROUP>
