Automation for inserting blank rows

Hello all,

I'm trying to insert a blank row at the end of the last finish date.

If the last row is 6/1/08, then i would like to insert a blank row that would say July 08

I've attached a sample spreadsheet. any assistance would be greatly appreciated.

Hi,

It's not clear (at least to me) what are your exact requirements.

The sample data has the dates in chronological order, hence the last date is the last row used - in this case row 117.
What do you mean by insert a row? Above row 117 or do you want to use the blank row 118?

Do I interpret 6/1/08 to mean June 1st 2008, or to those of us on the Eastern bank of the Atlantic, 6th January 2008?

If you do mean 6th January, (which seems consistent with the other dates in column F), how do you get from that January date to July 08?

When you say the blank row should say July 08, have you a particular cell in mind - presumably you mean the Finish Date column F, which implies F118, and do you want the text 'July 08' or an excel date number?

Regards

Hello,

Thank you for your assistance...

Let me try to clarified more.....

For example....in line 87 the end date is 11/30/2008 and then line 88 is 12/1/2008. I wanted to insert in between those 2 lines a blank row displaying December 2008 in bold and the row highlighted in yellow.

I want to do this starting from the top and go through all the end dates and insert the appropriate values.

hope that helps. thank you again.