Delete Rows with dates older than previous Friday

D

DoodlesMama

New Member
Joined
Aug 26, 2012
Messages
14
Hello,
I'm fairly new to VBA and currently automating a weekly report.

I extract this report from a sheet within a workbook managed by another department, then clean it up to be used as a source file for a larger report. Normally, I run this report on Fridays, but occasionally I'll do it over the weekend or Monday. All rows with a date (column H) older than the previous Friday must be deleted. For example, today is Friday, 5/31/13 so I need to delete all rows with a date greater than Friday, 5/24/13.

Although I know code that will delete rows exactly 7 days back, but I don't know how to create code that will use a date range and will pass this on to someone in an admin role after finishing the automation. Below is a sample of the report.

Thank you in advance for any who take the time to help me. ;)

[TABLE="width: 739"]
<TBODY>[TR]
[TD]A</SPAN>[/TD]
[TD]B</SPAN>[/TD]
[TD]C</SPAN>[/TD]
[TD]D</SPAN>[/TD]
[TD]E</SPAN>[/TD]
[TD]F</SPAN>[/TD]
[TD]G</SPAN>[/TD]
[TD]H</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD]J</SPAN>[/TD]
[TD]K</SPAN>[/TD]
[TD]L</SPAN>[/TD]
[TD]M</SPAN>[/TD]
[TD]N</SPAN>[/TD]
[TD]O</SPAN>[/TD]
[TD]P</SPAN>[/TD]
[/TR]
[TR]
[TD]ID</SPAN>[/TD]
[TD]SITE</SPAN>[/TD]
[TD]TYPE</SPAN>[/TD]
[TD]S/N</SPAN>[/TD]
[TD]STATE</SPAN>[/TD]
[TD] SCOPE</SPAN>[/TD]
[TD]PROFILE</SPAN>[/TD]
[TD] DATE</SPAN>[/TD]
[TD]SW_DATE</SPAN>[/TD]
[TD] SW </SPAN>[/TD]
[TD]FIX_DATE</SPAN>[/TD]
[TD] X_MODEL</SPAN>[/TD]
[TD] Y_MODEL </SPAN>[/TD]
[TD]Y_FIX_DATE</SPAN>[/TD]
[TD] X_FIX_DATE</SPAN>[/TD]
[TD] NAME</SPAN>[/TD]
[/TR]
[TR]
[TD]2473</SPAN>[/TD]
[TD]008169990</SPAN>[/TD]
[TD]720</SPAN>[/TD]
[TD]FGR01842</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]REFRESH</SPAN>[/TD]
[TD][/TD]
[TD]1/8/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]B. LOCKE</SPAN>[/TD]
[/TR]
[TR]
[TD]2713</SPAN>[/TD]
[TD]007998100</SPAN>[/TD]
[TD]750</SPAN>[/TD]
[TD]FGR06327</SPAN>[/TD]
[TD]FL</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]1/9/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]K. STEELE</SPAN>[/TD]
[/TR]
[TR]
[TD]2158</SPAN>[/TD]
[TD]000491936</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3300544</SPAN>[/TD]
[TD]IN</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/9/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]J. KIDWELL</SPAN>[/TD]
[/TR]
[TR]
[TD]1668</SPAN>[/TD]
[TD]001166297</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3301211</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/9/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]B. RAWLINS</SPAN>[/TD]
[/TR]
[TR]
[TD]500</SPAN>[/TD]
[TD]007023270</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3302066</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/9/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]M. PAPPAS</SPAN>[/TD]
[/TR]
[TR]
[TD]808</SPAN>[/TD]
[TD]006877260</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3307199</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/9/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]K. NENTWIG</SPAN>[/TD]
[/TR]
[TR]
[TD]905</SPAN>[/TD]
[TD]006877190</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]RGR00077</SPAN>[/TD]
[TD]MD</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/9/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]G. STINER </SPAN>[/TD]
[/TR]
[TR]
[TD]1777</SPAN>[/TD]
[TD]007136820</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]RGR01345</SPAN>[/TD]
[TD]KY</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/9/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]K. BAKER</SPAN>[/TD]
[/TR]
[TR]
[TD]2712</SPAN>[/TD]
[TD]007997260</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]RGR07493</SPAN>[/TD]
[TD]FL</SPAN>[/TD]
[TD]REFRESH</SPAN>[/TD]
[TD][/TD]
[TD]1/9/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]K. STEELE</SPAN>[/TD]
[/TR]
[TR]
[TD]1959</SPAN>[/TD]
[TD]000877134</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]RGR10674</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]REFRESH</SPAN>[/TD]
[TD][/TD]
[TD]1/9/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]J. HOLLAND</SPAN>[/TD]
[/TR]
[TR]
[TD]188</SPAN>[/TD]
[TD]005298650</SPAN>[/TD]
[TD]720</SPAN>[/TD]
[TD]V3301904</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/9/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]L. THOMAS</SPAN>[/TD]
[/TR]
[TR]
[TD]1664</SPAN>[/TD]
[TD]000921593</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3301208</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/10/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]B. RAWLINS</SPAN>[/TD]
[/TR]
[TR]
[TD]2034</SPAN>[/TD]
[TD]000308973</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3302074</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/10/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]J. HOLLAND</SPAN>[/TD]
[/TR]
[TR]
[TD]501</SPAN>[/TD]
[TD]000355149</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3304407</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/10/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]M. PAPPAS</SPAN>[/TD]
[/TR]
[TR]
[TD]187</SPAN>[/TD]
[TD]006877460</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3305905</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/10/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]L. THOMAS</SPAN>[/TD]
[/TR]
[TR]
[TD]2099</SPAN>[/TD]
[TD]007438020</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3306468</SPAN>[/TD]
[TD]IN</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/10/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]J. KIDWELL</SPAN>[/TD]
[/TR]
[TR]
[TD]2532</SPAN>[/TD]
[TD]000729715</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3317964</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/10/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]R. PERRY</SPAN>[/TD]
[/TR]
[TR]
[TD]1763</SPAN>[/TD]
[TD]001011790</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]RGR01930</SPAN>[/TD]
[TD]KY</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/10/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]R. HILL</SPAN>[/TD]
[/TR]
[TR]
[TD]2716</SPAN>[/TD]
[TD]000187195</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]RGR10675</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]REFRESH</SPAN>[/TD]
[TD][/TD]
[TD]1/10/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]B. LOCKE</SPAN>[/TD]
[/TR]
[TR]
[TD]809</SPAN>[/TD]
[TD]005461690</SPAN>[/TD]
[TD]720</SPAN>[/TD]
[TD]V3302295</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/10/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]K. NENTWIG</SPAN>[/TD]
[/TR]
[TR]
[TD]906</SPAN>[/TD]
[TD]005539890</SPAN>[/TD]
[TD]720</SPAN>[/TD]
[TD]VGR00062</SPAN>[/TD]
[TD]MD</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/10/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]G. STINER </SPAN>[/TD]
[/TR]
[TR]
[TD]1609</SPAN>[/TD]
[TD]007005680</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3304698</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/14/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]B. HITTE</SPAN>[/TD]
[/TR]
[TR]
[TD]2032</SPAN>[/TD]
[TD]005223900</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3305047</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/14/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]J. HOLLAND</SPAN>[/TD]
[/TR]
[TR]
[TD]162</SPAN>[/TD]
[TD]006879200</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3305416</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/14/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]L. THOMAS</SPAN>[/TD]
[/TR]
[TR]
[TD]2505</SPAN>[/TD]
[TD]000688507</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3305904</SPAN>[/TD]
[TD]NJ</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/14/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]K. DRAKE</SPAN>[/TD]
[/TR]
[TR]
[TD]798</SPAN>[/TD]
[TD]000359141</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3309877</SPAN>[/TD]
[TD]NJ</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/14/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]D. SALERNO</SPAN>[/TD]
[/TR]
[TR]
[TD]1002</SPAN>[/TD]
[TD]000644781</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3310723</SPAN>[/TD]
[TD]MD</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/14/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]T. ZINKAND</SPAN>[/TD]
[/TR]
[TR]
[TD]1428</SPAN>[/TD]
[TD]000593715</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3313280</SPAN>[/TD]
[TD]DC</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/14/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]G. STINER</SPAN>[/TD]
[/TR]
[TR]
[TD]1716</SPAN>[/TD]
[TD]007136850</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]RGR01905</SPAN>[/TD]
[TD]KY</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/14/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]R. HILL</SPAN>[/TD]
[/TR]
[TR]
[TD]2537</SPAN>[/TD]
[TD]006878660</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]RGR02442</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/14/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]J. ZARFOS</SPAN>[/TD]
[/TR]
[TR]
[TD]825</SPAN>[/TD]
[TD]006880070</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]RGR04511</SPAN>[/TD]
[TD]NJ</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/14/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]H. RIVERA</SPAN>[/TD]
[/TR]
[TR]
[TD]2106</SPAN>[/TD]
[TD]000534461</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]RGR10188</SPAN>[/TD]
[TD]IN</SPAN>[/TD]
[TD]REFRESH</SPAN>[/TD]
[TD][/TD]
[TD]1/14/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]J. KIDWELL</SPAN>[/TD]
[/TR]
[TR]
[TD]424</SPAN>[/TD]
[TD]001207802</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]RGR10282</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]REFRESH</SPAN>[/TD]
[TD][/TD]
[TD]1/14/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]M. PAPPAS</SPAN>[/TD]
[/TR]
[TR]
[TD]854</SPAN>[/TD]
[TD]006877510</SPAN>[/TD]
[TD]720</SPAN>[/TD]
[TD]V3302036</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/14/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]K. NENTWIG</SPAN>[/TD]
[/TR]
[TR]
[TD]855</SPAN>[/TD]
[TD]006877520</SPAN>[/TD]
[TD]720</SPAN>[/TD]
[TD]V3302037</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/14/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]R. LAMIHAUTE</SPAN>[/TD]
[/TR]
[TR]
[TD]473</SPAN>[/TD]
[TD]007023350</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3300319</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/15/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]M. PAPPAS</SPAN>[/TD]
[/TR]
[TR]
[TD]2108</SPAN>[/TD]
[TD]000609248</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3300975</SPAN>[/TD]
[TD]IN</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/15/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]J. KIDWELL</SPAN>[/TD]
[/TR]
[TR]
[TD]163</SPAN>[/TD]
[TD]000983197</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3301405</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/15/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]L. THOMAS</SPAN>[/TD]
[/TR]
[TR]
[TD]2533</SPAN>[/TD]
[TD]006879260</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3303924</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/15/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]L. FESSLER</SPAN>[/TD]
[/TR]
[TR]
[TD]1711</SPAN>[/TD]
[TD]002265250</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3307709</SPAN>[/TD]
[TD]KY</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/15/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]R. HILL</SPAN>[/TD]
[/TR]
[TR]
[TD]717</SPAN>[/TD]
[TD]005440160</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3312663</SPAN>[/TD]
[TD]FL</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/15/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]K. STEELE</SPAN>[/TD]
[/TR]
[TR]
[TD]1429</SPAN>[/TD]
[TD]006879590</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3313241</SPAN>[/TD]
[TD]DC</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/15/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]G. STINER</SPAN>[/TD]
[/TR]
[TR]
[TD]2506</SPAN>[/TD]
[TD]001606136</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3316463</SPAN>[/TD]
[TD]NJ</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/15/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]K. DRAKE</SPAN>[/TD]
[/TR]
[TR]
[TD]1023</SPAN>[/TD]
[TD]000102590</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3316881</SPAN>[/TD]
[TD]MD</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/15/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]M. MCKNIGHT</SPAN>[/TD]
[/TR]
[TR]
[TD]1583</SPAN>[/TD]
[TD]000718452</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3362598</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/15/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]J. HOLLAND</SPAN>[/TD]
[/TR]
[TR]
[TD]826</SPAN>[/TD]
[TD]006880090</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]RGR04512</SPAN>[/TD]
[TD]NJ</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/15/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]H. RIVERA</SPAN>[/TD]
[/TR]
[TR]
[TD]414</SPAN>[/TD]
[TD]000355305</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]RGR07195</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]REFRESH</SPAN>[/TD]
[TD][/TD]
[TD]1/15/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]M. WALLS</SPAN>[/TD]
[/TR]
[TR]
[TD]1107</SPAN>[/TD]
[TD]007022350</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]RGR09969</SPAN>[/TD]
[TD]IL</SPAN>[/TD]
[TD]REFRESH</SPAN>[/TD]
[TD][/TD]
[TD]1/15/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]T. SCHNEIDER</SPAN>[/TD]
[/TR]
[TR]
[TD]1610</SPAN>[/TD]
[TD]005091280</SPAN>[/TD]
[TD]720</SPAN>[/TD]
[TD]V3301536</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/15/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]B. HITTE</SPAN>[/TD]
[/TR]
[TR]
[TD]2589</SPAN>[/TD]
[TD]005122270</SPAN>[/TD]
[TD]720</SPAN>[/TD]
[TD]V3301574</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]1/15/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]B. LOCKE</SPAN>[/TD]
[/TR]
[TR]
[TD]1726</SPAN>[/TD]
[TD]000319749</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3300408</SPAN>[/TD]
[TD]KY</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]R. HILL</SPAN>[/TD]
[/TR]
[TR]
[TD]2150</SPAN>[/TD]
[TD]002317300</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3300541</SPAN>[/TD]
[TD]IN</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]J. KIDWELL</SPAN>[/TD]
[/TR]
[TR]
[TD]2155</SPAN>[/TD]
[TD]000975763</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3301432</SPAN>[/TD]
[TD]IN</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]C. MIRANDA</SPAN>[/TD]
[/TR]
[TR]
[TD]2042</SPAN>[/TD]
[TD]000721175</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3302140</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]M. WALLS</SPAN>[/TD]
[/TR]
[TR]
[TD]1285</SPAN>[/TD]
[TD]004753960</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3302197</SPAN>[/TD]
[TD]MO</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]M. BRADBURY</SPAN>[/TD]
[/TR]
[TR]
[TD]3212</SPAN>[/TD]
[TD]000649459</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3302207</SPAN>[/TD]
[TD]MI</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]M. BELKNAP</SPAN>[/TD]
[/TR]
[TR]
[TD]591</SPAN>[/TD]
[TD]000167320</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3302710</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]B. RAWLINS</SPAN>[/TD]
[/TR]
[TR]
[TD]3101</SPAN>[/TD]
[TD]004849090</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3302941</SPAN>[/TD]
[TD]IL</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]M. THOMAS</SPAN>[/TD]
[/TR]
[TR]
[TD]1809</SPAN>[/TD]
[TD]005215460</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3302962</SPAN>[/TD]
[TD]KY</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]K. BAKER</SPAN>[/TD]
[/TR]
[TR]
[TD]3120</SPAN>[/TD]
[TD]006877840</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3304664</SPAN>[/TD]
[TD]NJ</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]R. ROMAN</SPAN>[/TD]
[/TR]
[TR]
[TD]3144</SPAN>[/TD]
[TD]000690065</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3307757</SPAN>[/TD]
[TD]NJ</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]5</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]K. DRAKE</SPAN>[/TD]
[/TR]
[TR]
[TD]3270</SPAN>[/TD]
[TD]003992580</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3307905</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]5</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]B. LOCKE</SPAN>[/TD]
[/TR]
[TR]
[TD]949</SPAN>[/TD]
[TD]000275008</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3308543</SPAN>[/TD]
[TD]MD</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]5</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]C. STONE</SPAN>[/TD]
[/TR]
[TR]
[TD]811</SPAN>[/TD]
[TD]006878010</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3311604</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]K. NENTWIG</SPAN>[/TD]
[/TR]
[TR]
[TD]956</SPAN>[/TD]
[TD]002825740</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3313240</SPAN>[/TD]
[TD]MD</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]T. ZINKAND</SPAN>[/TD]
[/TR]
[TR]
[TD]137</SPAN>[/TD]
[TD]000736991</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]RGR01653</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]D. BALLISH</SPAN>[/TD]
[/TR]
[TR]
[TD]1514</SPAN>[/TD]
[TD]007407910</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]RGR02368</SPAN>[/TD]
[TD]VA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]W. EVANS</SPAN>[/TD]
[/TR]
[TR]
[TD]3128</SPAN>[/TD]
[TD]007587930</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]RGR03488</SPAN>[/TD]
[TD]NJ</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]H. RIVERA</SPAN>[/TD]
[/TR]
[TR]
[TD]3179</SPAN>[/TD]
[TD]000730341</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]RGR04911</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]R. PERRY</SPAN>[/TD]
[/TR]
[TR]
[TD]416</SPAN>[/TD]
[TD]007023310</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]RGR12577</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]REFRESH</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]B. KAEDING</SPAN>[/TD]
[/TR]
[TR]
[TD]1995</SPAN>[/TD]
[TD]007023040</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]RGR12582</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]REFRESH</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]M. VILLINGER</SPAN>[/TD]
[/TR]
[TR]
[TD]3292</SPAN>[/TD]
[TD]000686733</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]RGR12739</SPAN>[/TD]
[TD]NJ</SPAN>[/TD]
[TD]REFRESH</SPAN>[/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]A. CRUZ</SPAN>[/TD]
[/TR]
[TR]
[TD]2218</SPAN>[/TD]
[TD]007985470</SPAN>[/TD]
[TD]720</SPAN>[/TD]
[TD]VGR02718</SPAN>[/TD]
[TD]MD</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]5/22/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]M. DAVIS</SPAN>[/TD]
[/TR]
[TR]
[TD]1092</SPAN>[/TD]
[TD]007509980</SPAN>[/TD]
[TD]750</SPAN>[/TD]
[TD]F3306712</SPAN>[/TD]
[TD]IL</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]A. MALDONADO</SPAN>[/TD]
[/TR]
[TR]
[TD]1105</SPAN>[/TD]
[TD]001128230</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3300390</SPAN>[/TD]
[TD]IL</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]M. THOMAS</SPAN>[/TD]
[/TR]
[TR]
[TD]491</SPAN>[/TD]
[TD]000824755</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3301010</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]M. WALLS</SPAN>[/TD]
[/TR]
[TR]
[TD]1794</SPAN>[/TD]
[TD]000319368</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3301026</SPAN>[/TD]
[TD]KY</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]R. HILL</SPAN>[/TD]
[/TR]
[TR]
[TD]2073</SPAN>[/TD]
[TD]000610402</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3301064</SPAN>[/TD]
[TD]IN</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]C. MIRANDA</SPAN>[/TD]
[/TR]
[TR]
[TD]600</SPAN>[/TD]
[TD]001020403</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3301245</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]B. RAWLINS</SPAN>[/TD]
[/TR]
[TR]
[TD]1099</SPAN>[/TD]
[TD]000649970</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3302151</SPAN>[/TD]
[TD]MI</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]M. BELKNAP</SPAN>[/TD]
[/TR]
[TR]
[TD]1297</SPAN>[/TD]
[TD]000720276</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3302467</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]D. STAGGE</SPAN>[/TD]
[/TR]
[TR]
[TD]3125</SPAN>[/TD]
[TD]000796995</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3305200</SPAN>[/TD]
[TD]NJ</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]H. RIVERA</SPAN>[/TD]
[/TR]
[TR]
[TD]3138</SPAN>[/TD]
[TD]002881620</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3305703</SPAN>[/TD]
[TD]NJ</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]M. RIPPEY</SPAN>[/TD]
[/TR]
[TR]
[TD]3177</SPAN>[/TD]
[TD]005003970</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3306045</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]R. PERRY</SPAN>[/TD]
[/TR]
[TR]
[TD]2084</SPAN>[/TD]
[TD]005371060</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3306624</SPAN>[/TD]
[TD]IN</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]J. MCWHIRTER</SPAN>[/TD]
[/TR]
[TR]
[TD]138</SPAN>[/TD]
[TD]007020860</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3307845</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]D. BALLISH</SPAN>[/TD]
[/TR]
[TR]
[TD]2105</SPAN>[/TD]
[TD]000349753</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3308984</SPAN>[/TD]
[TD]IN</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]J. KIDWELL</SPAN>[/TD]
[/TR]
[TR]
[TD]3271</SPAN>[/TD]
[TD]001727312</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]R3309780</SPAN>[/TD]
[TD]NJ</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]A. CRUZ</SPAN>[/TD]
[/TR]
[TR]
[TD]3139</SPAN>[/TD]
[TD]001269992</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3310870</SPAN>[/TD]
[TD]NJ</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]R. ROMAN</SPAN>[/TD]
[/TR]
[TR]
[TD]860</SPAN>[/TD]
[TD]006878020</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3311581</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]K. NENTWIG</SPAN>[/TD]
[/TR]
[TR]
[TD]3325</SPAN>[/TD]
[TD]000461772</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3314149</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]B. LOCKE</SPAN>[/TD]
[/TR]
[TR]
[TD]3225</SPAN>[/TD]
[TD]006878360</SPAN>[/TD]
[TD]760</SPAN>[/TD]
[TD]R3314205</SPAN>[/TD]
[TD]DC</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]C. STONE</SPAN>[/TD]
[/TR]
[TR]
[TD]1424</SPAN>[/TD]
[TD]000593855</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]RGR04933</SPAN>[/TD]
[TD]MD</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]M. PANNILL</SPAN>[/TD]
[/TR]
[TR]
[TD]417</SPAN>[/TD]
[TD]000718924</SPAN>[/TD]
[TD]740</SPAN>[/TD]
[TD]RGR12706</SPAN>[/TD]
[TD]OH</SPAN>[/TD]
[TD]REFRESH</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]M. PAPPAS</SPAN>[/TD]
[/TR]
[TR]
[TD]3121</SPAN>[/TD]
[TD]004882160</SPAN>[/TD]
[TD]720</SPAN>[/TD]
[TD]V3301607</SPAN>[/TD]
[TD]NJ</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E</SPAN>[/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]K. DRAKE</SPAN>[/TD]
[/TR]
[TR]
[TD]966</SPAN>[/TD]
[TD]006779680</SPAN>[/TD]
[TD]720</SPAN>[/TD]
[TD]VGR00088</SPAN>[/TD]
[TD]MD</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]G. FALKO</SPAN>[/TD]
[/TR]
[TR]
[TD]1513</SPAN>[/TD]
[TD]007090250</SPAN>[/TD]
[TD]720</SPAN>[/TD]
[TD]VGR01025</SPAN>[/TD]
[TD]VA</SPAN>[/TD]
[TD]UPGRADE</SPAN>[/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]W. EVANS</SPAN>[/TD]
[/TR]
[TR]
[TD]1078</SPAN>[/TD]
[TD]007867060</SPAN>[/TD]
[TD]720</SPAN>[/TD]
[TD]VGR01559</SPAN>[/TD]
[TD]MD</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]M. DAVIS</SPAN>[/TD]
[/TR]
[TR]
[TD]2457</SPAN>[/TD]
[TD]008156760</SPAN>[/TD]
[TD]720</SPAN>[/TD]
[TD]VGR02725</SPAN>[/TD]
[TD]MD</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]M. DAVIS</SPAN>[/TD]
[/TR]
[TR]
[TD]2236</SPAN>[/TD]
[TD]008016640</SPAN>[/TD]
[TD]720</SPAN>[/TD]
[TD]VGR02931</SPAN>[/TD]
[TD]MD</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]5/23/2013</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]M. DAVIS</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL span=7><COL></COLGROUP>[/TABLE]
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Sort by date Sort by votes
Try something like this. Test this on a copy of your data.

Code: 
[color=darkblue]Sub[/color] Delete_Old()
    
    [color=darkblue]Dim[/color] d [color=darkblue]As[/color] [color=darkblue]Date[/color], i [color=darkblue]As[/color] [color=darkblue]Long[/color]
    
    d = [color=darkblue]Date[/color] - Weekday(Date, vbFriday) - 6  [color=green]'Most recent Friday - 7 days[/color]
    
    Application.ScreenUpdating = [color=darkblue]False[/color]
    [color=darkblue]For[/color] i = Range("H" & Rows.Count).End(xlUp).Row [color=darkblue]To[/color] 1 [color=darkblue]Step[/color] -1
        [color=darkblue]If[/color] Range("H" & i).Value < d [color=darkblue]Then[/color] Rows(i).Delete
    [color=darkblue]Next[/color] i
    Application.ScreenUpdating = [color=darkblue]True[/color]
    
[color=darkblue]End[/color] [color=darkblue]Sub[/color]
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Question Question
Converting Time Start/Stop Ranges to Presence/Absence
Replies
6
Views
255
myall_blues
myall_blues
S
  • Question Question
Date and Time difference not calculating over 30 days
Replies
5
Views
571
Stef9910
S
Asbestos_Jen
  • Question Question
Compare multiple parameters of samples to reference values (Excel 2007)
Replies
3
Views
349
Asbestos_Jen
Asbestos_Jen
X
  • Question Question
Need to pull a min or max date from multiple criteria
Replies
8
Views
760
KRice
K
H
  • Solved
Insert a blank row when the cell in column "B" changes.
2
Replies
10
Views
1K
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,223,714
Messages
6,174,058
Members
452,542
Latest member
Bricklin

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