I tried to assemble this myself through lurking on the forums, but it seems like its just outside my skill level right now.
I have a download that I get that shows activity for the company by Accounting Unit. With Sub Accts, Desc, Amt, and Date. I would like to try and develop a macro that copies the rows based on the Value in AcctUnit Column to the appropriate tab (the first 3 numbers in Acct Unit to match its tab) There will be times where there are multiple entries for one acctunit (rows 5&6 as example) An added bonus would be if i could get the Amount to paste in the correct columns on the corresponding tabs. Since this will be a monthly process where items do not always clear i don’t want this to paste over data that exists in the individual tabs.
I have attached a small portion of what i am working with for a better Visualization. I really appreciate any help available.
Thanks,
Brett
Data Dump
<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=0 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 75px"><COL style="WIDTH: 100px"><COL style="WIDTH: 84px"><COL style="WIDTH: 103px"><COL style="WIDTH: 87px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">ACCTUNIT</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">SUB-ACCOUNT</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">DESCRIPTION</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">BASE-AMOUNT</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">EFFECT-DATE</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: right">3000000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-17887.47</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: right">3010000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-26297.63</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: right">3020000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">54256.3</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right">3030000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-25122.63</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: right">3030000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-25121.63</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: right">3040000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-66298.9</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: right">5010000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-8626.09</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: right">5020000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-25512.75</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: right">5030000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-18402.58</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right">5040000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-21291.12</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: right">5050000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-6404.14</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: right">5060000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-12181.17</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: right">5070000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-24179.61</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: right">5080000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-17513.79</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: right">5090000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-26401.54</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: right">5100000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-25734.95</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: right">5130000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-13069.94</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: right">5140000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-12847.75</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: right">5150000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-398.88</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR></TBODY></TABLE>
301
<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=0 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 83px"><COL style="WIDTH: 35px"><COL style="WIDTH: 184px"><COL style="WIDTH: 78px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 76px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 65px"><COL style="WIDTH: 71px"><COL style="WIDTH: 71px"><COL style="WIDTH: 71px"><COL style="WIDTH: 56px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD><TD>N</TD><TD>O</TD><TD>P</TD><TD>Q</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; COLOR: #808000; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Health Care Facility</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; COLOR: #808000; FONT-SIZE: 10pt; FONT-WEIGHT: bold">301</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">ST Due From Related Party</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">3010000-143100-0000</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">September 30, 2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Trial Balance </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Variance</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> - </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">(26,297.63)</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">YTD Balance</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="FONT-FAMILY: Arial; COLOR: #c0c0c0; FONT-SIZE: 10pt">Account-Unit</TD><TD style="FONT-FAMILY: Arial; COLOR: #c0c0c0; FONT-SIZE: 10pt">SubAcct</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">DESCRIPTION</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">12/31/2010</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">1/31/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">2/28/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">3/31/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">4/30/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">5/31/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">6/30/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">7/31/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">8/31/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">9/30/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">10/31/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">11/30/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">12/31/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: right">3010000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD> </TD><TD> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right"> (26,298)</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">(26,298)</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">0</TD></TR></TBODY></TABLE>
I have a download that I get that shows activity for the company by Accounting Unit. With Sub Accts, Desc, Amt, and Date. I would like to try and develop a macro that copies the rows based on the Value in AcctUnit Column to the appropriate tab (the first 3 numbers in Acct Unit to match its tab) There will be times where there are multiple entries for one acctunit (rows 5&6 as example) An added bonus would be if i could get the Amount to paste in the correct columns on the corresponding tabs. Since this will be a monthly process where items do not always clear i don’t want this to paste over data that exists in the individual tabs.
I have attached a small portion of what i am working with for a better Visualization. I really appreciate any help available.
Thanks,
Brett
Data Dump
<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=0 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 75px"><COL style="WIDTH: 100px"><COL style="WIDTH: 84px"><COL style="WIDTH: 103px"><COL style="WIDTH: 87px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">ACCTUNIT</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">SUB-ACCOUNT</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">DESCRIPTION</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">BASE-AMOUNT</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">EFFECT-DATE</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: right">3000000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-17887.47</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: right">3010000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-26297.63</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: right">3020000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">54256.3</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right">3030000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-25122.63</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: right">3030000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-25121.63</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: right">3040000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-66298.9</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: right">5010000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-8626.09</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: right">5020000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-25512.75</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: right">5030000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-18402.58</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right">5040000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-21291.12</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: right">5050000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-6404.14</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: right">5060000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-12181.17</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: right">5070000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-24179.61</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: right">5080000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-17513.79</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: right">5090000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-26401.54</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: right">5100000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-25734.95</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: right">5130000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-13069.94</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: right">5140000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-12847.75</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: right">5150000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD style="TEXT-ALIGN: right">-398.88</TD><TD style="TEXT-ALIGN: right">9/1/2011</TD></TR></TBODY></TABLE>
301
<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=0 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 83px"><COL style="WIDTH: 35px"><COL style="WIDTH: 184px"><COL style="WIDTH: 78px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 76px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 65px"><COL style="WIDTH: 71px"><COL style="WIDTH: 71px"><COL style="WIDTH: 71px"><COL style="WIDTH: 56px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD><TD>N</TD><TD>O</TD><TD>P</TD><TD>Q</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; COLOR: #808000; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Health Care Facility</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; COLOR: #808000; FONT-SIZE: 10pt; FONT-WEIGHT: bold">301</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">ST Due From Related Party</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">3010000-143100-0000</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">September 30, 2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Trial Balance </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Variance</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> - </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">(26,297.63)</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">YTD Balance</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="FONT-FAMILY: Arial; COLOR: #c0c0c0; FONT-SIZE: 10pt">Account-Unit</TD><TD style="FONT-FAMILY: Arial; COLOR: #c0c0c0; FONT-SIZE: 10pt">SubAcct</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">DESCRIPTION</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">12/31/2010</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">1/31/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">2/28/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">3/31/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">4/30/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">5/31/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">6/30/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">7/31/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">8/31/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">9/30/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">10/31/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">11/30/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">12/31/2011</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">2011</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: right">3010000</TD><TD style="TEXT-ALIGN: right">824</TD><TD>Audit Fees</TD><TD> </TD><TD> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right"> (26,298)</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">(26,298)</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">0</TD></TR></TBODY></TABLE>