I'm stumped trying to figure out how to pull cells (in Columns B & C on Prior sheet) from one sheet to another sheet (Columns L & M on Sheet1) based on the person's name (column A on both sheets). One added variable that isn't helping me is that sheet1 and prior sheet won't always match up with the same people. When new people start they'll get added to Sheet1, but won't yet show up on prior sheet.
Is there a formula or formulas that I could use to accomplish this? Any help would be greatly appreciated. I've been working on it for quite a while, with no progress.
Sheet1:
<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><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><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;;">Department</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="font-weight: bold;;">Current as of 12.27.11</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">chargeable YTD</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">through prior month</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;"></td><td style=";">Values</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Values</td><td style="text-align: right;;"></td><td style="text-align: center;border-top: 1px solid black;color: #FFFFFF;background-color: #31869B;;">Prorated Budget</td><td style="text-align: center;border-top: 1px solid black;color: #FFFFFF;background-color: #31869B;;">+/- MTD</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";">Row Labels</td><td style=";">Bud Chg Hours</td><td style=";">Act Chg Hours</td><td style=";">Chg Variance</td><td style=";">Bud Total Hours</td><td style=";">Act Total Hours</td><td style=";">Total Variance</td><td style="border-bottom: 1px solid black;;">Bud Chg Hours</td><td style="border-bottom: 1px solid black;;">Act Chg Hours</td><td style="text-align: center;border-bottom: 1px solid black;color: #FFFFFF;background-color: #31869B;;"></td><td style="text-align: center;border-bottom: 1px solid black;color: #FFFFFF;background-color: #31869B;;"></td><td style="border-bottom: 1px solid black;;">Budget</td><td style="border-bottom: 1px solid black;;">+/- YTD</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style=";">Appleton</td><td style="text-align: right;;">1,963.00</td><td style="text-align: right;;">1,540.30</td><td style="text-align: right;;">(422.70)</td><td style="text-align: right;;">2,913.00</td><td style="text-align: right;;">2,290.85</td><td style="text-align: right;;">(622.15)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;color: #FFFFFF;background-color: #92CDDC;;">1,963.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;color: #FFFFFF;background-color: #92CDDC;;">1,540.30</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;color: #FFFFFF;background-color: #92CDDC;;">816</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;color: #FFFFFF;background-color: #92CDDC;;">(153)</td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="font-weight: bold;;">Accountant</td><td style="text-align: right;;">273.00</td><td style="text-align: right;;">189.30</td><td style="text-align: right;;">(83.70)</td><td style="text-align: right;;">399.00</td><td style="text-align: right;;">277.70</td><td style="text-align: right;;">(121.30)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #DAEEF3;;">273.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #DAEEF3;;">189.30</td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style=";">Smith, John</td><td style="text-align: right;;">143.00</td><td style="text-align: right;;">100.10</td><td style="text-align: right;;">(42.90)</td><td style="text-align: right;;">195.00</td><td style="text-align: right;;">142.30</td><td style="text-align: right;;">(52.70)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">143.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">100.10</td><td style="text-align: right;;">120</td><td style="text-align: right;;">-20</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style=";">Johnson,Sue</td><td style="text-align: right;;">130.00</td><td style="text-align: right;;">89.20</td><td style="text-align: right;;">(40.80)</td><td style="text-align: right;;">204.00</td><td style="text-align: right;;">135.40</td><td style="text-align: right;;">(68.60)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">130.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">89.20</td><td style="text-align: right;;">109</td><td style="text-align: right;;">-20</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="font-weight: bold;;">Accounting Assistant</td><td style="text-align: right;;">424.00</td><td style="text-align: right;;">298.40</td><td style="text-align: right;;">(125.60)</td><td style="text-align: right;;">548.00</td><td style="text-align: right;;">423.55</td><td style="text-align: right;;">(124.45)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #DAEEF3;;">424.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #DAEEF3;;">298.40</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style=";">Wolf, Bill</td><td style="text-align: right;;">153.00</td><td style="text-align: right;;">113.70</td><td style="text-align: right;;">(39.30)</td><td style="text-align: right;;">196.00</td><td style="text-align: right;;">146.00</td><td style="text-align: right;;">(50.00)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">153.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">113.70</td><td style="text-align: right;;">129</td><td style="text-align: right;;">-15</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style=";">Bush, Barb</td><td style="text-align: right;;">130.00</td><td style="text-align: right;;">100.55</td><td style="text-align: right;;">(29.45)</td><td style="text-align: right;;">176.00</td><td style="text-align: right;;">138.00</td><td style="text-align: right;;">(38.00)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">130.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">100.55</td><td style="text-align: right;;">109</td><td style="text-align: right;;">-9</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style=";">Rodgers, Aaron</td><td style="text-align: right;;">141.00</td><td style="text-align: right;;">84.15</td><td style="text-align: right;;">(56.85)</td><td style="text-align: right;;">176.00</td><td style="text-align: right;;">139.55</td><td style="text-align: right;;">(36.45)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">141.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">84.15</td><td style="text-align: right;;">119</td><td style="text-align: right;;">-35</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="font-weight: bold;;">Consultant</td><td style="text-align: right;;">0.00</td><td style="text-align: right;;">1.70</td><td style="text-align: right;;">1.70</td><td style="text-align: right;;">0.00</td><td style="text-align: right;;">1.70</td><td style="text-align: right;;">1.70</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #DAEEF3;;">0.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #DAEEF3;;">1.70</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style=";">Matthews, Clay</td><td style="text-align: right;;">0.00</td><td style="text-align: right;;">1.70</td><td style="text-align: right;;">1.70</td><td style="text-align: right;;">0.00</td><td style="text-align: right;;">1.70</td><td style="text-align: right;;">1.70</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">0.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">1.70</td><td style="text-align: right;;">0</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="font-weight: bold;;">Manager</td><td style="text-align: right;;">395.00</td><td style="text-align: right;;">276.30</td><td style="text-align: right;;">(118.70)</td><td style="text-align: right;;">629.00</td><td style="text-align: right;;">454.45</td><td style="text-align: right;;">(174.55)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #DAEEF3;;">395.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #DAEEF3;;">276.30</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style=";">Manning, Eli</td><td style="text-align: right;;">132.00</td><td style="text-align: right;;">63.00</td><td style="text-align: right;;">(69.00)</td><td style="text-align: right;;">200.00</td><td style="text-align: right;;">148.00</td><td style="text-align: right;;">(52.00)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">132.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">63.00</td><td style="text-align: right;;">111</td><td style="text-align: right;;">-48</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style=";">Manning, Peyton</td><td style="text-align: right;;">140.00</td><td style="text-align: right;;">110.50</td><td style="text-align: right;;">(29.50)</td><td style="text-align: right;;">214.00</td><td style="text-align: right;;">153.25</td><td style="text-align: right;;">(60.75)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">140.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">110.50</td><td style="text-align: right;;">118</td><td style="text-align: right;;">-7</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet1</p><br /><br />
Prior:
<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;;">Department</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="font-weight: bold;;">Current as of 12.27.11</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">BU - Team</td><td style=";"> Commercial</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">FY Calendar</td><td style=";">(Multiple Items)</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;"></td><td style=";">Values</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";">Row Labels</td><td style=";">Bud Chg Hours</td><td style=";">Chg Variance</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style=";">Appleton</td><td style="text-align: right;;">9,884.00</td><td style="text-align: right;;">(111.81)</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="font-weight: bold;;">Accountant</td><td style="text-align: right;;">1,449.00</td><td style="text-align: right;;">(79.65)</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style=";">Smith, john</td><td style="text-align: right;;">749.00</td><td style="text-align: right;;">(44.15)</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style=";">Johnson, Sue</td><td style="text-align: right;;">700.00</td><td style="text-align: right;;">(35.50)</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="font-weight: bold;;">Accounting Assistant</td><td style="text-align: right;;">2,222.00</td><td style="text-align: right;;">246.14</td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style=";">Wolf, Bill</td><td style="text-align: right;;">738.00</td><td style="text-align: right;;">42.50</td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style=";">Bush, Barb</td><td style="text-align: right;;">720.00</td><td style="text-align: right;;">(30.20)</td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style=";">Rodgers, Aaron</td><td style="text-align: right;;">764.00</td><td style="text-align: right;;">(50.05)</td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style=";">Longwell, Ryan</td><td style="text-align: right;;">0.00</td><td style="text-align: right;;">283.89</td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="font-weight: bold;;">Consultant</td><td style="text-align: right;;">0.00</td><td style="text-align: right;;">7.30</td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style=";">Matthews, Clay</td><td style="text-align: right;;">0.00</td><td style="text-align: right;;">7.30</td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="font-weight: bold;;">Director</td><td style="text-align: right;;">450.00</td><td style="text-align: right;;">(177.00)</td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style=";">Crosby, Sydney</td><td style="text-align: right;;">450.00</td><td style="text-align: right;;">(177.00)</td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="font-weight: bold;;">Manager</td><td style="text-align: right;;">1,339.00</td><td style="text-align: right;;">(21.80)</td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style=";">Manning, Eli</td><td style="text-align: right;;">366.00</td><td style="text-align: right;;">(13.00)</td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style=";">Manning, Peyton</td><td style="text-align: right;;">678.00</td><td style="text-align: right;;">(1.00)</td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">prior</p><br /><br />
Thanks for any help.
Ryan
Is there a formula or formulas that I could use to accomplish this? Any help would be greatly appreciated. I've been working on it for quite a while, with no progress.
Sheet1:
<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><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><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;;">Department</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="font-weight: bold;;">Current as of 12.27.11</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">chargeable YTD</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">through prior month</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;"></td><td style=";">Values</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Values</td><td style="text-align: right;;"></td><td style="text-align: center;border-top: 1px solid black;color: #FFFFFF;background-color: #31869B;;">Prorated Budget</td><td style="text-align: center;border-top: 1px solid black;color: #FFFFFF;background-color: #31869B;;">+/- MTD</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";">Row Labels</td><td style=";">Bud Chg Hours</td><td style=";">Act Chg Hours</td><td style=";">Chg Variance</td><td style=";">Bud Total Hours</td><td style=";">Act Total Hours</td><td style=";">Total Variance</td><td style="border-bottom: 1px solid black;;">Bud Chg Hours</td><td style="border-bottom: 1px solid black;;">Act Chg Hours</td><td style="text-align: center;border-bottom: 1px solid black;color: #FFFFFF;background-color: #31869B;;"></td><td style="text-align: center;border-bottom: 1px solid black;color: #FFFFFF;background-color: #31869B;;"></td><td style="border-bottom: 1px solid black;;">Budget</td><td style="border-bottom: 1px solid black;;">+/- YTD</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style=";">Appleton</td><td style="text-align: right;;">1,963.00</td><td style="text-align: right;;">1,540.30</td><td style="text-align: right;;">(422.70)</td><td style="text-align: right;;">2,913.00</td><td style="text-align: right;;">2,290.85</td><td style="text-align: right;;">(622.15)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;color: #FFFFFF;background-color: #92CDDC;;">1,963.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;color: #FFFFFF;background-color: #92CDDC;;">1,540.30</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;color: #FFFFFF;background-color: #92CDDC;;">816</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;color: #FFFFFF;background-color: #92CDDC;;">(153)</td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="font-weight: bold;;">Accountant</td><td style="text-align: right;;">273.00</td><td style="text-align: right;;">189.30</td><td style="text-align: right;;">(83.70)</td><td style="text-align: right;;">399.00</td><td style="text-align: right;;">277.70</td><td style="text-align: right;;">(121.30)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #DAEEF3;;">273.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #DAEEF3;;">189.30</td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style=";">Smith, John</td><td style="text-align: right;;">143.00</td><td style="text-align: right;;">100.10</td><td style="text-align: right;;">(42.90)</td><td style="text-align: right;;">195.00</td><td style="text-align: right;;">142.30</td><td style="text-align: right;;">(52.70)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">143.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">100.10</td><td style="text-align: right;;">120</td><td style="text-align: right;;">-20</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style=";">Johnson,Sue</td><td style="text-align: right;;">130.00</td><td style="text-align: right;;">89.20</td><td style="text-align: right;;">(40.80)</td><td style="text-align: right;;">204.00</td><td style="text-align: right;;">135.40</td><td style="text-align: right;;">(68.60)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">130.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">89.20</td><td style="text-align: right;;">109</td><td style="text-align: right;;">-20</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="font-weight: bold;;">Accounting Assistant</td><td style="text-align: right;;">424.00</td><td style="text-align: right;;">298.40</td><td style="text-align: right;;">(125.60)</td><td style="text-align: right;;">548.00</td><td style="text-align: right;;">423.55</td><td style="text-align: right;;">(124.45)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #DAEEF3;;">424.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #DAEEF3;;">298.40</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style=";">Wolf, Bill</td><td style="text-align: right;;">153.00</td><td style="text-align: right;;">113.70</td><td style="text-align: right;;">(39.30)</td><td style="text-align: right;;">196.00</td><td style="text-align: right;;">146.00</td><td style="text-align: right;;">(50.00)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">153.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">113.70</td><td style="text-align: right;;">129</td><td style="text-align: right;;">-15</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style=";">Bush, Barb</td><td style="text-align: right;;">130.00</td><td style="text-align: right;;">100.55</td><td style="text-align: right;;">(29.45)</td><td style="text-align: right;;">176.00</td><td style="text-align: right;;">138.00</td><td style="text-align: right;;">(38.00)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">130.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">100.55</td><td style="text-align: right;;">109</td><td style="text-align: right;;">-9</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style=";">Rodgers, Aaron</td><td style="text-align: right;;">141.00</td><td style="text-align: right;;">84.15</td><td style="text-align: right;;">(56.85)</td><td style="text-align: right;;">176.00</td><td style="text-align: right;;">139.55</td><td style="text-align: right;;">(36.45)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">141.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">84.15</td><td style="text-align: right;;">119</td><td style="text-align: right;;">-35</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="font-weight: bold;;">Consultant</td><td style="text-align: right;;">0.00</td><td style="text-align: right;;">1.70</td><td style="text-align: right;;">1.70</td><td style="text-align: right;;">0.00</td><td style="text-align: right;;">1.70</td><td style="text-align: right;;">1.70</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #DAEEF3;;">0.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #DAEEF3;;">1.70</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style=";">Matthews, Clay</td><td style="text-align: right;;">0.00</td><td style="text-align: right;;">1.70</td><td style="text-align: right;;">1.70</td><td style="text-align: right;;">0.00</td><td style="text-align: right;;">1.70</td><td style="text-align: right;;">1.70</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">0.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">1.70</td><td style="text-align: right;;">0</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="font-weight: bold;;">Manager</td><td style="text-align: right;;">395.00</td><td style="text-align: right;;">276.30</td><td style="text-align: right;;">(118.70)</td><td style="text-align: right;;">629.00</td><td style="text-align: right;;">454.45</td><td style="text-align: right;;">(174.55)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #DAEEF3;;">395.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #DAEEF3;;">276.30</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style=";">Manning, Eli</td><td style="text-align: right;;">132.00</td><td style="text-align: right;;">63.00</td><td style="text-align: right;;">(69.00)</td><td style="text-align: right;;">200.00</td><td style="text-align: right;;">148.00</td><td style="text-align: right;;">(52.00)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">132.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">63.00</td><td style="text-align: right;;">111</td><td style="text-align: right;;">-48</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style=";">Manning, Peyton</td><td style="text-align: right;;">140.00</td><td style="text-align: right;;">110.50</td><td style="text-align: right;;">(29.50)</td><td style="text-align: right;;">214.00</td><td style="text-align: right;;">153.25</td><td style="text-align: right;;">(60.75)</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">140.00</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">110.50</td><td style="text-align: right;;">118</td><td style="text-align: right;;">-7</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet1</p><br /><br />
Prior:
<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;;">Department</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="font-weight: bold;;">Current as of 12.27.11</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">BU - Team</td><td style=";"> Commercial</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">FY Calendar</td><td style=";">(Multiple Items)</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;"></td><td style=";">Values</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";">Row Labels</td><td style=";">Bud Chg Hours</td><td style=";">Chg Variance</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style=";">Appleton</td><td style="text-align: right;;">9,884.00</td><td style="text-align: right;;">(111.81)</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="font-weight: bold;;">Accountant</td><td style="text-align: right;;">1,449.00</td><td style="text-align: right;;">(79.65)</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style=";">Smith, john</td><td style="text-align: right;;">749.00</td><td style="text-align: right;;">(44.15)</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style=";">Johnson, Sue</td><td style="text-align: right;;">700.00</td><td style="text-align: right;;">(35.50)</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="font-weight: bold;;">Accounting Assistant</td><td style="text-align: right;;">2,222.00</td><td style="text-align: right;;">246.14</td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style=";">Wolf, Bill</td><td style="text-align: right;;">738.00</td><td style="text-align: right;;">42.50</td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style=";">Bush, Barb</td><td style="text-align: right;;">720.00</td><td style="text-align: right;;">(30.20)</td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style=";">Rodgers, Aaron</td><td style="text-align: right;;">764.00</td><td style="text-align: right;;">(50.05)</td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style=";">Longwell, Ryan</td><td style="text-align: right;;">0.00</td><td style="text-align: right;;">283.89</td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="font-weight: bold;;">Consultant</td><td style="text-align: right;;">0.00</td><td style="text-align: right;;">7.30</td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style=";">Matthews, Clay</td><td style="text-align: right;;">0.00</td><td style="text-align: right;;">7.30</td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="font-weight: bold;;">Director</td><td style="text-align: right;;">450.00</td><td style="text-align: right;;">(177.00)</td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style=";">Crosby, Sydney</td><td style="text-align: right;;">450.00</td><td style="text-align: right;;">(177.00)</td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="font-weight: bold;;">Manager</td><td style="text-align: right;;">1,339.00</td><td style="text-align: right;;">(21.80)</td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style=";">Manning, Eli</td><td style="text-align: right;;">366.00</td><td style="text-align: right;;">(13.00)</td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style=";">Manning, Peyton</td><td style="text-align: right;;">678.00</td><td style="text-align: right;;">(1.00)</td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">prior</p><br /><br />
Thanks for any help.
Ryan
