Can this be done with Excel formulas?

What I'm trying to do is get Excel to insert a set of months under year headings with two columns of data beside them (invoice no. and date of payment) based on the number of payment installments and a starting date I enter into a cell.

For example...

No. of installments: 8
Starting date: 1st July 2007

...would create the output...

2007

July
August
September
October
November
December

2008

January
February

The two columns next to the month entries can remain blank as they will be filled in by hand on the printouts, though I'd like horizontal lines to appear in the cells to write above.

Any ideas?

Thanks for the helpful replies everyone. Yes, I suppose you'd call it a payment schedule, except it will be used to manually record when customers actually paid say, January's recurring invoice, rather than when they were supposed to. Each company has, or will have, a schedule for each new deal.

It's a lot of unnecessary hassle if you ask me seeing as all this information is already being tracked with Sage Line 50. I'm not entirely sure why these paper backups are held in such high regard because I've only worked for this company for a week. At this stage it's not a good idea to rock the boat by daring to suggest that a long-standing procedure is a waste of time.

Anyway I've already setup this spreadsheet to work out half a dozen figures based on the values I enter (aside from the manual figures) so most of the hard work has already been automated. I just thought this extra step would be the icing on the cake, and impress the boss to boot.

Like you say, Applespider, it's child's play to do the corner dragging thing. I can live with that. 🙂