How to automatically insert multiple rows & insert dates into new rows

bcragg · Apr 20, 2011

I saved a screen print on google docs that illustrates my question. Below is the link. I couldn't figure out how to upload an image.

 https://docs.google.com/leaf?id=0B7vQ46Z5w-oyMjFmNjlkY2YtODZhYy00MjFmLTgxMGItNTg2OWY2NGZhNjkx&hl=en

Thanks for your help!

VoG · Apr 20, 2011

Can you copy what you have in column E (assuming that contains the dates) and paste it in a reply to this thread.

bcragg · Apr 20, 2011

Rick,
Your code worked with no bugs, but it stops after the 2nd row of original data. Is this fixable?

Thank you kindly!
Bryan

bcragg · Apr 20, 2011

VoG said:
Can you copy what you have in column E (assuming that contains the dates) and paste it in a reply to this thread.

I saved it to google docs below... for some reason, when I tried pasting the text of Column E, my Firefox browser would freeze.

https://spreadsheets.google.com/ccc?key=0ArvQ46Z5w-oydHc2R3U0bjRrMjdBS3pZVnJvaS03U0E&hl=en

VoG · Apr 20, 2011

It would be easier to just copy and paste here. Are you actually using Excel or Google whatever?

bcragg · Apr 20, 2011

VoG said:
It would be easier to just copy and paste here. Are you actually using Excel or Google whatever?

I'm using excel... I will try to copy and paste again.

<table border="0" cellpadding="0" cellspacing="0" width="97"><col style="width: 73pt;" width="97"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; width: 73pt;" width="97" height="20">Required Date</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/16/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/23/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/6/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/13/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/20/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/4/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/11/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/2/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/9/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/23/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/6/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/27/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/11/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/9/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/23/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/13/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/27/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/2/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/9/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/16/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/30/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/6/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/13/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/20/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/27/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/4/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/11/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/8/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/15/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/22/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/29/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/12/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/19/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/26/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/2/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/9/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/16/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/30/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/6/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/13/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/20/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/27/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/4/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/11/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/8/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/15/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/22/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/29/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/12/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/19/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/26/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/9/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/23/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/30/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/6/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/9/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/13/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/20/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/27/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/4/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/11/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/20/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/11/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/15/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/26/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/2/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/9/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/16/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/23/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/30/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/6/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/13/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/20/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/4/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/11/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/8/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/15/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/22/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/29/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/12/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/19/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/26/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/16/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/30/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/20/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/27/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/11/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/2/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/23/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/30/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/27/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/4/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/11/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/6/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/2/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/16/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/23/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/13/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/27/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/4/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/11/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/9/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/6/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/9/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/16/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/6/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/4/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/4/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/9/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/30/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/16/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/9/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/13/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/2/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/9/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/16/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/23/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/30/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/8/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/15/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/22/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/29/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/12/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/19/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/26/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/2/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/9/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/16/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/30/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/6/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/13/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/20/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/27/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/4/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/11/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/8/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/15/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/22/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/29/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/12/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/19/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/26/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/2/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/9/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/16/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/23/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/30/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/6/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/13/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/2/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/9/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/16/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/23/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/30/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/6/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/13/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/20/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/27/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/8/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/15/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/22/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/29/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/12/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/19/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/26/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/2/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/9/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/16/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/23/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/30/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/6/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/13/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/20/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/27/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/8/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/15/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/22/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/29/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/12/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/19/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/26/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/2/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/9/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/16/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/23/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/30/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/6/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/13/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/20/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/27/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/8/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/15/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/22/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/29/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/12/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/19/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/26/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">4/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/2/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/9/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/16/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/23/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">5/30/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/6/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/13/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/20/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/27/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/18/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/25/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/8/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/15/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/22/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/29/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/12/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/19/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/26/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">6/6/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">7/11/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">8/1/2011</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 73pt;" width="97" height="20">9/5/2011</td> </tr> </tbody></table>

VoG · Apr 20, 2011

The dates must be sorted ascending for the macro to work.

bcragg · Apr 20, 2011

VoG said:
The dates must be sorted ascending for the macro to work.

Ok... That makes sense. My problem is that I have multiple part numbers, so where the dates start over, is where I have a new part number starting in column A.

I can work around that though.

Rick Rothstein · Apr 20, 2011

bcragg said:
When I run Rick's code it works, but only for the first 2 rows of original data, it doesn't work for the entire contiguous sheet.

What row does your data start on? Peter's code assumed Row 3 whereas I assumed Row 2. If your data does not start on Row 2, look at my code and change the 2 in the following line to whatever row number contains your first piece of data...

Const StartRow As Long = 2

I suspect this is why my code only works partially for you.

Rick Rothstein · Apr 20, 2011

bcragg said:
My problem is that I have multiple part numbers, so where the dates start over, is where I have a new part number starting in column A.

Does this modification to my original macro work for your existing data set...

Code:

Sub FillDates()
  Dim LastRow As Long, PreviousDataRow As Long, R As Range
  Const StartRow As Long = 2
  LastRow = Cells(Rows.Count, "A").End(xlUp).Row
  On Error Resume Next
  For Each R In Range(Rows(StartRow + 1), Rows(LastRow)).Rows
    If Cells(R.Row, "A").Value = Cells(R.Row - 1, "A").Value And _
       Cells(R.Row, "B").Value = Cells(R.Row - 1, "B").Value And _
       Cells(R.Row, "C").Value = Cells(R.Row - 1, "C").Value Then
      R.Resize(Cells(R.Row, "E").Value - Cells(R.Row - 1, "E").Value - 1).Insert
    End If
  Next
  LastRow = Cells(Rows.Count, "A").End(xlUp).Row
  For Each R In Range(Cells(StartRow, "E"), Cells(LastRow, "E")).SpecialCells(xlCellTypeBlanks).Areas
    R.Offset(-1).Resize(R.Rows.Count + 1).DataSeries Type:=xlChronological
  Next
  On Error GoTo 0
End Sub

How to automatically insert multiple rows & insert dates into new rows

bcragg

New Member

VoG

Legend

Excel Facts

bcragg

New Member

bcragg

New Member

VoG

Legend

bcragg

New Member

VoG

Legend

bcragg

New Member

Rick Rothstein

MrExcel MVP

Rick Rothstein

MrExcel MVP

Similar threads

Forum statistics

Share this page

How to automatically insert multiple rows & insert dates into new rows

New Member

Legend

Excel Facts

New Member

New Member

Legend

New Member

Legend

New Member

MrExcel MVP

MrExcel MVP

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock