I have simplified the spreadsheet below and my needs are less as a result. I would like the spreadsheet to use the current month to identify the appropriate column of information (So, since we are in August, the spreadsheet should target the August Column). Then I would like the spreadsheet to subtract the current MONTHLY OUTLAY (highlighted row) from the previous month's MONTHLY OUTLAY, displaying the resulting amount in Cell J1 (Highlighted). In this case, I would like the spreadsheet to find the $850.00 in the August Monthly Outlay, subtract it from the $2,273.24 in the July Monthly Outlay and put the resulting amount in Cell J1. When September rolls around, the spreadsheet will know to subtract the September Monthly Outlay from the August Monthly Outlay, etc.
<table border="0" cellpadding="0" cellspacing="0" width="1269"><colgroup><col style="mso-width-source:userset;mso-width-alt:6948;width:143pt" width="190"> <col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="mso-width-source:userset;mso-width-alt:3108;width:64pt" width="85"> <col style="mso-width-source:userset;mso-width-alt:3072;width:63pt" width="84"> <col style="mso-width-source:userset;mso-width-alt:3145;width:65pt" width="86"> <col style="mso-width-source:userset;mso-width-alt:3291;width:68pt" width="90"> <col style="mso-width-source:userset;mso-width-alt:2998;width:62pt" width="82"> <col style="mso-width-source:userset;mso-width-alt:3035;width:62pt" width="83"> <col style="mso-width-source:userset;mso-width-alt:4022;width:83pt" width="110"> <col style="mso-width-source:userset;mso-width-alt:4169;width:86pt" width="114"> <col style="mso-width-source:userset;mso-width-alt:3035;width:62pt" width="83"> <col style="mso-width-source:userset;mso-width-alt:2998;width:62pt" width="82"> <col style="mso-width-source:userset;mso-width-alt:3072;width:63pt" width="84"> </colgroup><tbody><tr style="mso-height-source:userset;height:42.0pt" height="56"> <td class="xl95" style="height:42.0pt;width:143pt" height="56" width="190">Bill Tracker 9000</td> <td class="xl99" style="width:72pt" width="96">
</td> <td class="xl99" style="width:64pt" align="right" width="85">2011</td> <td class="xl92" style="width:63pt" width="84">
</td> <td class="xl99" colspan="4" style="mso-ignore:colspan;width:257pt" width="341"> Outstanding Balance for</td> <td class="xl100" style="width:83pt" width="110">Aug-11</td> <td class="xl101" style="width:86pt" width="114">
$1,423.24</td> <td class="xl92" style="width:62pt" width="83">
</td> <td class="xl92" style="width:62pt" width="82">
</td> <td class="xl92" style="width:63pt" width="84">
</td> </tr> <tr style="mso-height-source:userset;height:13.5pt" height="18"> <td class="xl97" style="height:13.5pt" height="18">
</td> <td class="xl84" style="border-left:none">
</td> <td class="xl84" style="border-left:none">
</td> <td class="xl84" style="border-left:none">
</td> <td class="xl84" style="border-left:none">
</td> <td class="xl84" style="border-left:none">
</td> <td class="xl84" style="border-left:none">
</td> <td class="xl84" style="border-left:none">
</td> <td class="xl98" style="border-left:none">
</td> <td class="xl98" style="border-left:none">
</td> <td class="xl98" style="border-left:none">
</td> <td class="xl98" style="border-left:none">
</td> <td class="xl98" style="border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">2011</td> <td class="xl96">J January
</td> <td class="xl96" style="border-left:none">February</td> <td class="xl96" style="border-left:none">March</td> <td class="xl96" style="border-left:none">April</td> <td class="xl96" style="border-left:none">May</td> <td class="xl96" style="border-left:none">June</td> <td class="xl96" style="border-left:none">July</td> <td class="xl96" style="border-left:none">August</td> <td class="xl96" style="border-left:none">September</td> <td class="xl96" style="border-left:none">October</td> <td class="xl96" style="border-left:none">November</td> <td class="xl96" style="border-left:none">December</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl74" style="height:15.0pt" height="20">Cash In - Okay to update</td> <td class="xl79" style="border-top:none;border-left:none" align="right">$4,500.00</td> <td class="xl79" style="border-top:none;border-left:none" align="right">$5,395.00</td> <td class="xl79" style="border-top:none;border-left:none" align="right">$7,324.00</td> <td class="xl79" style="border-top:none;border-left:none" align="right">$3,903.00</td> <td class="xl79" style="border-top:none;border-left:none" align="right">$7,978.00</td> <td class="xl79" style="border-top:none;border-left:none" align="right">$4,680.89</td> <td class="xl79" style="border-top:none;border-left:none" align="right">$4,410.00</td> <td class="xl79" style="border-top:none;border-left:none" align="right">$1,463.54</td> <td class="xl79" style="border-top:none;border-left:none">
</td> <td class="xl79" style="border-top:none;border-left:none">
</td> <td class="xl79" style="border-top:none;border-left:none">
</td> <td class="xl79" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl75" style="height:15.0pt;border-top:none" height="20">Cash Remaining - Do NOT Update</td> <td class="xl80" style="border-top:none;border-left:none" align="right">$1,085.81</td> <td class="xl80" style="border-top:none;border-left:none" align="right">$2,856.31</td> <td class="xl80" style="border-top:none;border-left:none" align="right">$1,861.22</td> <td class="xl80" style="border-top:none;border-left:none" align="right">$1,775.85</td> <td class="xl80" style="border-top:none;border-left:none" align="right">$5,804.11</td> <td class="xl80" style="border-top:none;border-left:none" align="right">$2,364.67</td> <td class="xl80" style="border-top:none;border-left:none" align="right">$2,136.76</td> <td class="xl80" style="border-top:none;border-left:none" align="right">$613.54</td> <td class="xl80" style="border-top:none;border-left:none">
</td> <td class="xl80" style="border-top:none;border-left:none">
</td> <td class="xl80" style="border-top:none;border-left:none">
</td> <td class="xl80" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl71" style="height:15.0pt;border-top:none" height="20">
Monthly Outlay</td> <td class="xl72" style="border-top:none">
$3,414.19</td> <td class="xl72" style="border-top:none">
$2,538.69</td> <td class="xl72" style="border-top:none">
$5,462.78</td> <td class="xl72" style="border-top:none">
$2,127.15</td> <td class="xl72" style="border-top:none">
$2,173.89</td> <td class="xl72" style="border-top:none">
$2,316.22</td> <td class="xl72" style="border-top:none">
$2,273.24</td> <td class="xl72" style="border-top:none">
$850.00</td> <td class="xl72" style="border-top:none">
$0.00</td> <td class="xl72" style="border-top:none">
$0.00</td> <td class="xl72" style="border-top:none">
$0.00</td> <td class="xl72" style="border-top:none">
$0.00</td> </tr> <tr style="mso-height-source:userset;height:7.5pt" height="10"> <td class="xl65" style="height:7.5pt" height="10">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> </tr> <tr style="mso-height-source:userset;height:17.25pt" height="23"> <td class="xl81" style="height:17.25pt" height="23">Ad Hoc Spending</td> <td class="xl82" style="border-left:none">$742.50</td> <td class="xl82" style="border-left:none">$969.00</td> <td class="xl82" style="border-left:none">$20.00</td> <td class="xl82" style="border-left:none">$55.69</td> <td class="xl82" style="border-left:none">$439.00</td> <td class="xl82" style="border-left:none">$500.00</td> <td class="xl82" style="border-left:none">$42.72</td> <td class="xl82" style="border-left:none">
</td> <td class="xl82" style="border-left:none">
</td> <td class="xl82" style="border-left:none">
</td> <td class="xl82" style="border-left:none">
</td> <td class="xl82" style="border-left:none">
</td> </tr> <tr style="mso-height-source:userset;height:7.5pt" height="10"> <td class="xl65" style="height:7.5pt" height="10">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl93" style="height:15.0pt" height="20">Bill 1</td> <td class="xl85" style="border-left:none">1/24</td> <td class="xl85">2/25</td> <td class="xl85">3/25</td> <td class="xl85">4/30</td> <td class="xl85">5/26</td> <td class="xl85">6/24</td> <td class="xl85">7/25</td> <td class="xl85">
</td> <td class="xl85">
</td> <td class="xl85">
</td> <td class="xl85">
</td> <td class="xl86">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">Check Number</td> <td class="xl83" style="border-left:none">2265</td> <td class="xl83" style="border-left:none">2284</td> <td class="xl83" style="border-left:none">2292</td> <td class="xl83" style="border-left:none">2305</td> <td class="xl83" style="border-left:none">2314</td> <td class="xl83" style="border-left:none">2319</td> <td class="xl83" style="border-left:none">2328</td> <td class="xl83" style="border-left:none">
</td> <td class="xl83" style="border-left:none">
</td> <td class="xl83" style="border-left:none">
</td> <td class="xl83" style="border-left:none">
</td> <td class="xl83" style="border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl69" style="height:15.0pt;border-top:none" height="20">Payment </td> <td class="xl76" style="border-top:none;border-left:none" align="right">$1,018.19</td> <td class="xl76" style="border-top:none;border-left:none" align="right">$1,111.19</td> <td class="xl76" style="border-top:none;border-left:none" align="right">$1,111.19</td> <td class="xl76" style="border-top:none;border-left:none" align="right">$1,111.19</td> <td class="xl76" style="border-top:none;border-left:none" align="right">$1,111.19</td> <td class="xl76" style="border-top:none;border-left:none" align="right">$1,111.19</td> <td class="xl76" style="border-top:none;border-left:none" align="right">$1,111.19</td> <td class="xl76" style="border-top:none;border-left:none">
</td> <td class="xl76" style="border-top:none;border-left:none">
</td> <td class="xl76" style="border-top:none;border-left:none">
</td> <td class="xl76" style="border-top:none;border-left:none">
</td> <td class="xl76" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl87" style="height:15.0pt;border-top:none" height="20">Balance *****</td> <td class="xl88" style="border-top:none;border-left:none" align="right">$118,062.00</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$117,886.00</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$117,710.00</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$117,534.00</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$117,358.00</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$117,182.00</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$117,000.28</td> <td class="xl77" style="border-top:none;border-left:none">
</td> <td class="xl77" style="border-top:none;border-left:none">
</td> <td class="xl77" style="border-top:none;border-left:none">
</td> <td class="xl77" style="border-top:none;border-left:none">
</td> <td class="xl77" style="border-top:none;border-left:none">
</td> </tr> <tr style="mso-height-source:userset;height:3.0pt" height="4"> <td class="xl89" style="height:3.0pt" height="4">
</td> <td class="xl90">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl91" style="border-top:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl93" style="height:15.0pt" height="20">Bill 2</td> <td class="xl85" style="border-left:none">1/14 & 1/28</td> <td class="xl85">2/8</td> <td class="xl85">3/10</td> <td class="xl85">4/18</td> <td class="xl85">5/5</td> <td class="xl85">6/1</td> <td class="xl85">7/1</td> <td class="xl85">8/6</td> <td class="xl85">
</td> <td class="xl85">
</td> <td class="xl85">
</td> <td class="xl86">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">Check Number</td> <td class="xl83" style="border-left:none">Dirpay</td> <td class="xl83" style="border-left:none">Dirpay</td> <td class="xl83" style="border-left:none">Dirpay</td> <td class="xl83" style="border-left:none">Dirpay</td> <td class="xl83" style="border-left:none">Dirpay</td> <td class="xl83" style="border-left:none">Dirpay</td> <td class="xl83" style="border-left:none">Dirpay</td> <td class="xl83" style="border-left:none">Dirpay</td> <td class="xl83" style="border-left:none">Dirpay</td> <td class="xl83" style="border-left:none">Dirpay</td> <td class="xl83" style="border-left:none">Dirpay</td> <td class="xl83" style="border-left:none">Dirpay</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl69" style="height:15.0pt;border-top:none" height="20">Payment </td> <td class="xl76" style="border-top:none;border-left:none" align="right">$1,630.00</td> <td class="xl76" style="border-top:none;border-left:none" align="right">$420.00</td> <td class="xl76" style="border-top:none;border-left:none" align="right">$4,308.09</td> <td class="xl76" style="border-top:none;border-left:none" align="right">$936.77</td> <td class="xl76" style="border-top:none;border-left:none" align="right">$600.00</td> <td class="xl76" style="border-top:none;border-left:none" align="right">$665.73</td> <td class="xl76" style="border-top:none;border-left:none" align="right">$1,095.03</td> <td class="xl76" style="border-top:none;border-left:none" align="right">$850.00</td> <td class="xl76" style="border-top:none;border-left:none">
</td> <td class="xl76" style="border-top:none;border-left:none">
</td> <td class="xl76" style="border-top:none;border-left:none">
</td> <td class="xl76" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">Balance *****</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$2,200.00</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$4,066.00</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$0.00</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$0.00</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$270.00</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$77.56</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$0.00</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$0.00</td> <td class="xl77" style="border-top:none;border-left:none">
</td> <td class="xl77" style="border-top:none;border-left:none">
</td> <td class="xl77" style="border-top:none;border-left:none">
</td> <td class="xl77" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl90" style="border-top:none">
</td> <td class="xl91" style="border-top:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl94" style="height:15.0pt" height="20">Bill 3</td> <td class="xl73" style="border-top:none;border-left:none">1/12</td> <td class="xl73" style="border-top:none">2/11</td> <td class="xl73" style="border-top:none">3/10</td> <td class="xl73" style="border-top:none">4/14</td> <td class="xl73" style="border-top:none">5/11</td> <td class="xl73" style="border-top:none">6/14</td> <td class="xl73" style="border-top:none">7/14</td> <td class="xl73" style="border-top:none">
</td> <td class="xl73" style="border-top:none">
</td> <td class="xl73" style="border-top:none">
</td> <td class="xl73" style="border-top:none">
</td> <td class="xl78" style="border-top:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">Check Number</td> <td class="xl83" style="border-left:none">2263</td> <td class="xl83" style="border-left:none">2272</td> <td class="xl83" style="border-left:none">2290</td> <td class="xl83" style="border-left:none">2299</td> <td class="xl83" style="border-left:none">2310</td> <td class="xl83" style="border-left:none">2317</td> <td class="xl83" style="border-left:none">2327</td> <td class="xl83" style="border-left:none">
</td> <td class="xl83" style="border-left:none">
</td> <td class="xl83" style="border-left:none">
</td> <td class="xl83" style="border-left:none">
</td> <td class="xl83" style="border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl69" style="height:15.0pt;border-top:none" height="20">Payment </td> <td class="xl76" style="border-top:none;border-left:none" align="right">$23.50</td> <td class="xl76" style="border-top:none;border-left:none" align="right">$38.50</td> <td class="xl76" style="border-top:none;border-left:none" align="right">$23.50</td> <td class="xl76" style="border-top:none;border-left:none" align="right">$23.50</td> <td class="xl76" style="border-top:none;border-left:none" align="right">$23.70</td> <td class="xl76" style="border-top:none;border-left:none" align="right">$39.30</td> <td class="xl76" style="border-top:none;border-left:none" align="right">$24.30</td> <td class="xl76" style="border-top:none;border-left:none">
</td> <td class="xl76" style="border-top:none;border-left:none">
</td> <td class="xl76" style="border-top:none;border-left:none">
</td> <td class="xl76" style="border-top:none;border-left:none">
</td> <td class="xl76" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">Balance *****</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$0.00</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$0.00</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$0.00</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$0.00</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$0.00</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$0.00</td> <td class="xl77" style="border-top:none;border-left:none" align="right">$0.00</td> <td class="xl77" style="border-top:none;border-left:none">
</td> <td class="xl77" style="border-top:none;border-left:none">
</td> <td class="xl77" style="border-top:none;border-left:none">
</td> <td class="xl77" style="border-top:none;border-left:none">
</td> <td class="xl77" style="border-top:none;border-left:none">
</td> </tr> </tbody></table>
