Separating Dates With Blank Rows

J

Justinian

Well-known Member
Joined
Aug 9, 2009
Messages
1,557
Office Version
  1. 365
Platform
  1. Windows
I have a massive spreadsheet with after-hours air requests from tenants but the dates are not spearated. i want to be able to quickly separted 5/8 from 5/9, 5/9 from 5/10, etc., so that I can have a blank row under each date for a total.

How can i quickly do this? VBA??
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Sort by date Sort by votes
Welcome to MrExcel board....

try this

Code: 
Sub InsertRow()
Dim LR As Long, i As Long
LR = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row
For i = LR To 2 Step -1
    If Cells(i, "A") <> Cells(i + 1, "A") Then
        Rows(i + 1).Insert Shift:=xlDown
    End If
Next i
End Sub
 
Upvote 0
Thank you for this code! It almost works perfectly, let me show you the orginal doc:
<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:183px;" /><col style="width:244px;" /><col style="width:130px;" /><col style="width:101px;" /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Granted Access [64574]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >McClellan, Kevin</td><td style="text-align:left; ">5/1/2011 8:46</td><td style="text-align:left; ">64574</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/2/2011 18:04</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/2/2011 20:28</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >Granted Access [63845]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Gardea, Victor</td><td style="text-align:left; ">5/2/2011 22:44</td><td style="text-align:left; ">63845</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/2/2011 22:49</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >Granted Access [62878]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Wostenberg, Eric</td><td style="text-align:left; ">5/3/2011 18:04</td><td style="text-align:left; ">62878</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td >Granted Access [62878]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Wostenberg, Eric</td><td style="text-align:left; ">5/3/2011 18:04</td><td style="text-align:left; ">62878</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td >Granted Access [62878]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Wostenberg, Eric</td><td style="text-align:left; ">5/3/2011 18:04</td><td style="text-align:left; ">62878</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/3/2011 18:05</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/3/2011 20:26</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/3/2011 22:56</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td >Granted Access [63845]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Gardea, Victor</td><td style="text-align:left; ">5/4/2011 0:42</td><td style="text-align:left; ">63845</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/4/2011 18:05</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/4/2011 20:15</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/4/2011 22:18</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td >Granted Access [63845]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Gardea, Victor</td><td style="text-align:left; ">5/5/2011 2:08</td><td style="text-align:left; ">63845</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/5/2011 18:01</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/5/2011 20:10</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/5/2011 22:23</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/6/2011 0:27</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel tables to the web >> </span><a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de/index.php?f=1

And here is after running the code:
<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:183px;" /><col style="width:244px;" /><col style="width:130px;" /><col style="width:101px;" /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Granted Access [64574]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >McClellan, Kevin</td><td style="text-align:left; ">5/1/2011 8:46</td><td style="text-align:left; ">64574</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/2/2011 18:04</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/2/2011 20:28</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >Granted Access [63845]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Gardea, Victor</td><td style="text-align:left; ">5/2/2011 22:44</td><td style="text-align:left; ">63845</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/2/2011 22:49</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td >Granted Access [62878]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Wostenberg, Eric</td><td style="text-align:left; ">5/3/2011 18:04</td><td style="text-align:left; ">62878</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td >Granted Access [62878]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Wostenberg, Eric</td><td style="text-align:left; ">5/3/2011 18:04</td><td style="text-align:left; ">62878</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td >Granted Access [62878]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Wostenberg, Eric</td><td style="text-align:left; ">5/3/2011 18:04</td><td style="text-align:left; ">62878</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/3/2011 18:05</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/3/2011 20:26</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/3/2011 22:56</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td >Granted Access [63845]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Gardea, Victor</td><td style="text-align:left; ">5/4/2011 0:42</td><td style="text-align:left; ">63845</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/4/2011 18:05</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/4/2011 20:15</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >23</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/4/2011 22:18</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >25</td><td >Granted Access [63845]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Gardea, Victor</td><td style="text-align:left; ">5/5/2011 2:08</td><td style="text-align:left; ">63845</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >26</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >27</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/5/2011 18:01</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >28</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/5/2011 20:10</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >29</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/5/2011 22:23</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >30</td><td >Granted Access [63401]</td><td >ALLIANZ_Delux 3rd Floor HVAC Control</td><td >Brady, Denise</td><td style="text-align:left; ">5/6/2011 0:27</td><td style="text-align:left; ">63401</td><td style="text-align:right; ">235</td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel tables to the web >> </span><a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de/index.php?f=1
 
Upvote 0
Try the following code:
Code: 
Public Sub SplitDates()
Dim i   As Long, _
    LR  As Long
    
With Application
    .ScreenUpdating = False
    .Calculation = xlCalculationManual
End With
LR = Range("D" & Rows.Count).End(xlUp).Row
For i = LR To 3 Step -1
    If Month(Range("D" & i - 1).Value) <> Month(Range("D" & i).Value) Or Day(Range("D" & i - 1).Value) <> Day(Range("D" & i).Value) Then
        Rows(i).Insert shift:=xlDown
    End If
Next i
With Application
    .ScreenUpdating = True
    .Calculation = xlCalculationAutomatic
End With
End Sub

Which, given your original table, produces the following results:
<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;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></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [64574]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">McClellan, Kevin</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/1/2011 8:46</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">64574</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [63401]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Brady, Denise</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/2/2011 18:04</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">63401</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [63401]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Brady, Denise</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/2/2011 20:28</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">63401</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [63845]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Gardea, Victor</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/2/2011 22:44</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">63845</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [63401]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Brady, Denise</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/2/2011 22:49</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">63401</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [62878]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Wostenberg, Eric</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/3/2011 18:04</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">62878</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [62878]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Wostenberg, Eric</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/3/2011 18:04</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">62878</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [62878]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Wostenberg, Eric</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/3/2011 18:04</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">62878</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [63401]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Brady, Denise</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/3/2011 18:05</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">63401</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [63401]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Brady, Denise</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/3/2011 20:26</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">63401</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [63401]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Brady, Denise</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/3/2011 22:56</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">63401</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [63845]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Gardea, Victor</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/4/2011 0:42</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">63845</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [63401]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Brady, Denise</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/4/2011 18:05</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">63401</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [63401]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Brady, Denise</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/4/2011 20:15</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">63401</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [63401]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Brady, Denise</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/4/2011 22:18</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">63401</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [63845]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Gardea, Victor</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/5/2011 2:08</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">63845</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [63401]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Brady, Denise</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/5/2011 18:01</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">63401</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [63401]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Brady, Denise</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/5/2011 20:10</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">63401</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [63401]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Brady, Denise</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/5/2011 22:23</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">63401</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;"></td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Granted Access [63401]</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">ALLIANZ_Delux 3rd Floor HVAC Control</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">Brady, Denise</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">5/6/2011 0:27</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">63401</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">235</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 #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br />
 
Upvote 0
****, that worked perfectly!! How did you get the code to run so fast and seemlessly?

What is a public sub?
 
Upvote 0
Justinian said:
****, that worked perfectly!! How did you get the code to run so fast and seemlessly?

What is a public sub?
Click to expand...

By turning off ScreenUpdating and Calculations, it takes a huge load off of calculations due to rows being adjusted and re-rendering the screen (rendering the screen is actually pretty taxing on the CPU).

Any sub that you declare (without calling it a Private Sub) is automatically a "Public Sub". A Public Sub can be called from anywhere, regardless of module location. I always try to explicitly declare everything out of habit and coding practice.

Glad the code worked for you, and thank you for the feedback! ;)
 
Upvote 0
Sweet! Thank you for the expeditious reply and info, it really helped me today.
 
Upvote 0
One more problem! I have this spreadsheet below, sorted by building. Can you run a similar code to separate by month, in column H, instead of by day?

@TASK185_-03

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 105px"><COL style="WIDTH: 69px"><COL style="WIDTH: 47px"><COL style="WIDTH: 138px"><COL style="WIDTH: 68px"><COL style="WIDTH: 47px"><COL style="WIDTH: 68px"><COL style="WIDTH: 60px"></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></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="FONT-SIZE: 8pt">S16000804943</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">12/28/2009</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1901</TD><TD style="FONT-SIZE: 8pt">1/10 Trash Removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">174.55</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">174.55</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1/21/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="FONT-SIZE: 8pt">S16000804943</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">12/28/2009</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1901</TD><TD style="FONT-SIZE: 8pt">1/10 Trash Removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">117.83</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">117.83</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1/21/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-SIZE: 8pt">S150419H</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">12/31/2009</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1901</TD><TD style="FONT-SIZE: 8pt">Remove Debris</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">36.19</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">36.19</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1/21/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-SIZE: 8pt">S150773H</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1/22/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1901</TD><TD style="FONT-SIZE: 8pt">Remove Pallets</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">18.36</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">18.36</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">2/11/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-SIZE: 8pt">S16000820567</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1/28/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1901</TD><TD style="FONT-SIZE: 8pt">2/10 Trash removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">206.97</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">206.97</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">2/18/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 8pt">S16000837182</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">2/28/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1901</TD><TD style="FONT-SIZE: 8pt">3/10 Trash Removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">117.83</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">117.83</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">4/9/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 8pt">S16000866474</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">3/28/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1901</TD><TD style="FONT-SIZE: 8pt">4/10 Trash Removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">235.66</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">235.66</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">4/29/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-SIZE: 8pt">S16000881978</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">4/28/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1901</TD><TD style="FONT-SIZE: 8pt">5/10 Trash removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">117.83</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">117.83</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">5/27/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-SIZE: 8pt">S151495H</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">5/24/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1901</TD><TD style="FONT-SIZE: 8pt">Debris Removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">37.21</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">37.21</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">6/17/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-SIZE: 8pt">S151593H</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">5/25/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1901</TD><TD style="FONT-SIZE: 8pt">Debris Removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">30.31</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">30.31</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">6/17/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-SIZE: 8pt">S16000898099</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">5/28/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1901</TD><TD style="FONT-SIZE: 8pt">6/10 Trash removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">117.83</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">117.83</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">6/24/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-SIZE: 8pt">S16000927554</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">6/28/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1901</TD><TD style="FONT-SIZE: 8pt">7/10 Trash Removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">117.83</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">117.83</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">7/22/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-SIZE: 8pt">S16000944006</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">7/28/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1901</TD><TD style="FONT-SIZE: 8pt">8/10 Trash removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">117.83</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">117.83</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">8/19/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 8pt">S16001023892</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">11/28/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1901</TD><TD style="FONT-SIZE: 8pt">12/10 Trash Removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">570.45</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">570.45</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">12/30/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-SIZE: 8pt">S16000804943</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">12/28/2009</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1902</TD><TD style="FONT-SIZE: 8pt">1/10 Trash Removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">174.55</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">174.55</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1/21/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD style="FONT-SIZE: 8pt">S16000804943</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">12/28/2009</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1902</TD><TD style="FONT-SIZE: 8pt">1/10 Trash Removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">117.83</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">117.83</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1/21/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</TD><TD style="FONT-SIZE: 8pt">S150419H</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">12/31/2009</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1902</TD><TD style="FONT-SIZE: 8pt">Remove Debris</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">51.55</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">51.55</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1/21/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">20</TD><TD style="FONT-SIZE: 8pt">S150773H</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1/22/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1902</TD><TD style="FONT-SIZE: 8pt">Remove Pallets</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">26.16</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">26.16</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">2/11/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">21</TD><TD style="FONT-SIZE: 8pt">S16000820567</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1/28/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1902</TD><TD style="FONT-SIZE: 8pt">2/10 Trash removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">174.55</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">174.55</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">2/18/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">22</TD><TD style="FONT-SIZE: 8pt">S16000837182</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">2/28/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1902</TD><TD style="FONT-SIZE: 8pt">3/10 Trash Removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">292.38</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">292.38</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">4/9/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">23</TD><TD style="FONT-SIZE: 8pt">S16000866474</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">3/28/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1902</TD><TD style="FONT-SIZE: 8pt">4/10 Trash Removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">174.55</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">174.55</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">4/29/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">24</TD><TD style="FONT-SIZE: 8pt">S16000881978</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">4/28/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1902</TD><TD style="FONT-SIZE: 8pt">5/10 Trash removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">379.94</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">379.94</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">5/27/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">25</TD><TD style="FONT-SIZE: 8pt">S151495H</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">5/24/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1902</TD><TD style="FONT-SIZE: 8pt">Debris Removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">53.01</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">53.01</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">6/17/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">26</TD><TD style="FONT-SIZE: 8pt">S151593H</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">5/25/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1902</TD><TD style="FONT-SIZE: 8pt">Debris Removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">43.18</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">43.18</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">6/17/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">27</TD><TD style="FONT-SIZE: 8pt">S16000898099</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">5/28/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1902</TD><TD style="FONT-SIZE: 8pt">6/10 Trash removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">292.38</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">292.38</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">6/24/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">28</TD><TD style="FONT-SIZE: 8pt">S16000927554</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">6/28/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1902</TD><TD style="FONT-SIZE: 8pt">7/10 Trash Removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">292.38</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">292.38</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">7/22/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">29</TD><TD style="FONT-SIZE: 8pt">S16000944006</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">7/28/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1902</TD><TD style="FONT-SIZE: 8pt">8/10 Trash removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">292.38</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">292.38</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">8/19/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">30</TD><TD style="FONT-SIZE: 8pt">S16000961439</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">8/28/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1902</TD><TD style="FONT-SIZE: 8pt">9/10 Trash removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">292.38</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">292.38</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">10/1/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">31</TD><TD style="FONT-SIZE: 8pt">S16000990906</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">9/28/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1902</TD><TD style="FONT-SIZE: 8pt">10/10 Trash removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">292.38</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">292.38</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">10/15/2010</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">32</TD><TD style="FONT-SIZE: 8pt">S16001023892</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">11/28/2010</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1902</TD><TD style="FONT-SIZE: 8pt">12/10 Trash Removal</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">292.38</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">0.00</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">292.38</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">12/30/2010</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1
 
Upvote 0
You must log in or register to reply here.

Similar threads

DPChristman
  • Question Question
File too big - Causes excel to not respond for several minutes.
Replies
2
Views
79
Joe4
Joe4
S
  • Question Question
Auto protect certain columns after 5 minutes inactivity
Replies
1
Views
113
SKuser
S
G
  • Question Question
V/Hlookup or Index/Match assistance Required?
Replies
7
Views
101
etaf
etaf
M
  • Question Question
CountIfs Help
Replies
9
Views
131
Joe4
Joe4
D
  • Question Question
Countif / Sum including a date range
Replies
4
Views
242
djjamesp
D

Forum statistics

Threads
1,224,594
Messages
6,179,794
Members
452,943
Latest member
Newbie4296

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