I have a spreadsheet that needs row to repeat at the top (which I did) but I also need rows to repeat at the bottom (preferable option). If I can't do that I need to put a page border. This is for business so it needs to look professional. The biggest problem is that the number and width of the cells on each page change, sometimes it will fit 50 rows, other time only 30 depending on the amount of text, so I can't just re-type the bottom rows every 20 rows. I tried putting it in the footer, but then I can't get a border on that.

I tried a few macro tricks, but I don't know macro well so I can't get them to work.

Please help.