Excel - this is a tough one... conditional footers.
Posted on 2014-08-11
I've attached a redacted copy of a macro-enabled file. One of the macros is event-based: 'Insert row with double-click.'
The problem is that as rows are added, Excel pushes cells G27:M38 down the page, splitting the range of cells and pushing some of it to the next page. I want that range to ONLY appear on the last page.
Example: If there are 1-9 line item rows, then there will be room on the first page for the 'TERMS / Signature' cells to be a 'footer' on the last page. But if the salesperson adds more than 9 line item rows, then the TERMS section rows start getting split up.
What I want is for the TERMS section to be at the bottom of the LAST page ONLY. So if the sheet has more than 9 'Line Items' on it, the entire TERMS section gets pushed to the bottom of the second page. And if more line items are added, such that page 2 has more than 9 line items, the TERMS section gets pushed to the bottom of page 3, etc.
It's like a conditional footer - a footer that only appears on the last page.
On a related note, I can't figure out how to even create a footer (not that I need to in this case) on this sheet, since it has 'Freeze Panes' turned on.
Disclaimer - the macros in this workbook were created by others. I don't know VBA, and am very grateful for the help I've gotten here with this workbook.