Need to Adjust Macro to compare reports

M

Mldeuser

Well-known Member
Joined
Dec 27, 2008
Messages
573
Office Version
  1. 365
Platform
  1. Windows
I can use some help in adjusting the macro below so that instead of comparing the tenant names it compares the lease id (Column "B" on the Prepaid Rent Worksheet and Column "A" on the Aged Delinquent Worksheet) and then brings back the same information as before

Thanks
Mark







Sub Aged_Delinquent_Click()
ActiveSheet.Unprotect Password:="cbre1"
For MY_ROWS = 11 To Range("C" & Rows.Count).End(xlUp).Row - 1
If Not IsEmpty(Range("C" & MY_ROWS).Value) Then
Range("D" & MY_ROWS).ClearContents
End If
Next MY_ROWS
MsgBox "Did you download the current Aged Delinquent Report"
Dim c As Range
Dim Aging As Worksheet
Dim AgingTotals As Range
Dim PrepaidNames As Range
Dim CustomerName As String
Dim FoundCustomer As Range

Set Aging = Sheet24
Set AgingTotals = Sheet24.Range("A1", Aging.Range("A65536").End(xlUp))
Set PrepaidNames = Sheet33.Range("C:C")
For Each c In AgingTotals
If Right(c, 6) = "Total:" Then
CustomerName = Left(c, Len(c) - 7)
Set FoundCustomer = PrepaidNames.Find(CustomerName, LookIn:=xlValues, lookat:=xlWhole)
If FoundCustomer Is Nothing Then
Range("C11").EntireRow.Insert
Range("C11") = CustomerName
Range("D11") = c.Offset(0, 4)
Range("G6").Copy Range("G11")
Else
FoundCustomer.Offset(0, 1) = c.Offset(0, 4)

End If
End If
Next c


ActiveSheet.Protect DrawingObjects:=False, Contents:=True, Scenarios:= _
False, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True, AllowInsertingRows:=True, AllowDeletingRows:= _
True, AllowSorting:=True
ActiveSheet.EnableSelection = xlNoRestrictions



Prepaid Rent

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Times New Roman,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 122px"><COL style="WIDTH: 285px"><COL style="WIDTH: 120px"><COL style="WIDTH: 119px"><COL style="WIDTH: 104px"><COL style="WIDTH: 111px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">KBS Realty Advisors</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">North Creek Center Parkway</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">Prepaid Rent Per Period Ended 07/09</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">Balance </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">as of</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">Misc Bill Back</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">Estimate</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">Adjusted</TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-SIZE: 12pt">Lease ID</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">Tenant</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">7/31/2009</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">Accruals</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">KBS</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">Tenant Balance</TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-SIZE: 12pt">R21010-CB0634</TD><TD style="FONT-SIZE: 12pt">Wyandotte Federal Credit Union</TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: left"> 1,302.74 </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> 1,302.74 </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-SIZE: 12pt">R21011-CB0623</TD><TD style="FONT-SIZE: 12pt">Wachovia Securities, LLC</TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: left"> 5,352.66 </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> 5,352.66 </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-SIZE: 12pt">R21010-CB0680</TD><TD style="FONT-SIZE: 12pt">TCG New Jersey</TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: left"> 0.01 </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> 0.01 </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 12pt">R21010-CB0645</TD><TD style="FONT-SIZE: 12pt">Shionogi USA, Inc</TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: left"> 1,179.82 </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> 1,179.82 </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-SIZE: 12pt">R21010-CB0635</TD><TD style="FONT-SIZE: 12pt">Merrill Lynch, P, F & S, Inc</TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: left"> 10,495.76 </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> 10,495.76 </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-SIZE: 12pt">R21010-CB0642</TD><TD style="FONT-SIZE: 12pt">Lipton Corp Child Care Centers</TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: left"> 600.99 </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> 600.99 </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-SIZE: 12pt">R21010-CB0647</TD><TD style="FONT-SIZE: 12pt">Hartford Fire Insurance Co.</TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: left"> 7,201.83 </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> 7,201.83 </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD style="FONT-SIZE: 12pt">R21011-CB0915</TD><TD style="FONT-SIZE: 12pt">Holliday Fenoglio Fowler, LP</TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: left"> 2,729.11 </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> 2,729.11 </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</TD><TD style="FONT-SIZE: 12pt">R21010-CB0633</TD><TD style="FONT-SIZE: 12pt">Hisamitsu Pharmaceutical Co</TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: left"> - </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> - </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">20</TD><TD style="FONT-SIZE: 12pt">R21010-CB0639</TD><TD style="FONT-SIZE: 12pt">Eisner, LLP</TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: left"> 1,458.82 </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> 1,458.82 </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">21</TD><TD style="FONT-SIZE: 12pt">R21010-CB0639</TD><TD style="FONT-SIZE: 12pt">Eisner, LLP</TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: left"> 20,007.75 </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> 20,007.75 </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">22</TD><TD style="FONT-SIZE: 12pt">R21011-CB0620</TD><TD style="FONT-SIZE: 12pt">Day Pitney, LLP</TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: left"> 30,577.02 </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> 30,577.02 </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">23</TD><TD style="FONT-SIZE: 12pt">R21011-CB0887</TD><TD style="FONT-SIZE: 12pt">Citigroup Global Markets, Inc</TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: left"> 3,343.51 </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> 3,343.51 </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">24</TD><TD style="FONT-SIZE: 12pt">R21010-CB0684</TD><TD style="FONT-SIZE: 12pt">CB Richard Ellis</TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: left"> - </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> - </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">25</TD><TD style="FONT-SIZE: 12pt">R21010-CB0682</TD><TD style="FONT-SIZE: 12pt">Cablevision Lightpath-NJ</TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: left"> 1,040.00 </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> 1,040.00 </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">26</TD><TD style="FONT-SIZE: 12pt">R21010-CB0630</TD><TD style="FONT-SIZE: 12pt">BASF Corp & BASF Americas Corp</TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: left"> - </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> - </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">27</TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> - </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">28</TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> - </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">29</TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> - </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">30</TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> - </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">31</TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> - </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">32</TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> - </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">33</TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right"> - </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">34</TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">35</TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD></TR><TR style="HEIGHT: 24px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">36</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">Per Total Aged Delinquency Balance</TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: right">85,290.02 </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: right">0.00 </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: right">0.00 </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: right">85,290.02 </TD></TR><TR style="HEIGHT: 24px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">37</TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">38</TD><TD style="FONT-SIZE: 12pt">Tenant Rec per A/R Balance Report@07/09(A/C 1110 & 1115)</TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right">85,290.02 </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">39</TD><TD style="FONT-SIZE: 12pt">Prepaid Rent per A/R Balance Report @07/09(A/C 2065)</TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: right">0.00 </TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">40</TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">41</TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: right">85,290.02 </TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">42</TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD><TD style="FONT-SIZE: 12pt"> </TD></TR></TBODY></TABLE>


Aged Delinquent

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Times New Roman,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 233px"><COL style="WIDTH: 56px"><COL style="WIDTH: 142px"><COL style="WIDTH: 56px"><COL style="WIDTH: 131px"><COL style="WIDTH: 65px"><COL style="WIDTH: 65px"><COL style="WIDTH: 75px"><COL style="WIDTH: 80px"><COL style="WIDTH: 56px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><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></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Database: KBSREALTY2</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Aged Delinquencies</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Page:</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">1</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">KBSREALTY 2 Database</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Date:</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">9/8/2009</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Time:</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">02:33 PM</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Period: 09/09</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Invoice Date</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Category</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Source</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Amount</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Current</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">1 Month</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">2 Months</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">3 Months</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">4 Months</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">R21010-CB0630</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; FONT-FAMILY: Arial">BASF Corp & BASF Americas Corp</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Master Occupant Id: BASF Cor-1</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Day Due: 1</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Delq Day:</TD><TD style="FONT-FAMILY: Arial"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Bill Pearson</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">400</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Current</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Last Payment:</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">8/24/2009</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">21,986</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">(973) 245-6598</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">8/14/2009</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">PPD</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Prepaid Rent</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">CR</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">-494,018.96</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">-494,018.96</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">9/1/2009</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">PTX</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Property Tax Recovery</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">CH</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">1,241.71</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">1,241.71</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">9/1/2009</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">PTX</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Property Tax Recovery</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">CH</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">164.85</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">164.85</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">9/1/2009</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">RNT</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Base Rent</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">CH</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">235,043.23</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">235,043.23</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">9/1/2009</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">RNT</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Base Rent</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">CH</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">136,795.21</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">136,795.21</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">9/1/2009</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">RNT</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Base Rent</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">CH</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">120,773.96</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">120,773.96</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">20</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">21</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">PPD</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Prepaid Rent</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">-494,019</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">-494,019</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">22</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">PTX</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Property Tax Recovery</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">1,407</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">1,407</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">23</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">RNT</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Base Rent</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">492,612</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">492,612</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">24</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; FONT-FAMILY: Arial">BASF Corp & BASF Americas Corp Total:</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">494,019</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">-494,019</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">25</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">26</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">27</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">R21010-CB0682</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; FONT-FAMILY: Arial">Cablevision Lightpath-NJ</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Master Occupant Id: Cablevis-1</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Day Due: 1</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Delq Day:</TD><TD style="FONT-FAMILY: Arial"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">28</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Mark A. Cline</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">TELC</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Current</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Last Payment:</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">8/6/2009</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">1,040</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">29</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">(516) 803-6771</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">30</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">9/1/2009</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">RNT</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Base Rent</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">CH</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">1,040.00</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">1,040.00</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">31</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">32</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">RNT</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Base Rent</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">1,040</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">1,040</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">33</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; FONT-FAMILY: Arial">Cablevision Lightpath-NJ Total:</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">1,040</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">1,040</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">34</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">35</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">36</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">R21010-CB0684</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; FONT-FAMILY: Arial">CB Richard Ellis</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Master Occupant Id: CBRichar-1</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Day Due: 1</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Delq Day:</TD><TD style="FONT-FAMILY: Arial"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">37</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">115A</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Current</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Last Payment:</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">6/4/2009</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">8,928</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">38</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">(973) 966-6692</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">39</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">9/1/2009</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">FRE</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Free Rent</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">NC</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">-0.01</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">-0.01</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">40</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">9/1/2009</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">RNT</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Base Rent</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">CH</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0.01</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0.01</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">41</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">42</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">FRE</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Free Rent</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">43</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">RNT</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Base Rent</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">44</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; FONT-FAMILY: Arial">CB Richard Ellis Total:</TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-FAMILY: Arial"> </TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">0</TD></TR></TBODY></TABLE>
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
You must log in or register to reply here.

Similar threads

E
  • Question
Adding a custom message.
Replies
1
Views
451
Micron
M
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
859
gvsumich
G
A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
J
  • Question
Outlook Hypperlink of fila in email body will not open
Replies
1
Views
463
josros60
J

Forum statistics

Threads
1,215,737
Messages
6,126,562
Members
449,318
Latest member
Son Raphon

Share this page

We've detected that you are using an adblocker.

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

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

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

Disable uBlock

Follow these easy steps to disable uBlock

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