I have a spreadsheet i can write data from FMPro to.  There is a "Header" (row 2) with a bunch of column titles, and a "Footer" (row12) with some text under where i put the individual child data. The "Header" and "Footer" are static, never change (except the sum column which is a formula). 

There are 10 rows between my "Header" row and the "Footer" row. If there are more than 10 kids data to put on the spreadsheet I need to insert another new row just above the "footer" row, row 12. 

Is there a way to insert a row on the spreadsheet at row 12, so that it moves the current row 12 down (now row 13)so I can add an 11th child's data to the sheet?  

I have this issue with multiple spreadsheets, a need to insert rows on demand...........

Any help is greatly appreciated. 

 

 

Decided that I will just ad xtra lines manually, then have the user delete what is not needed. They have to open the file anyway to look at and print it.