Hello, I have had a quote form I created many years ago that I am updating. The quote form uses VLOOKUP functions to grab information such as cost and descriptions from another sheet that we populate with our suppliers price lists. I used to have it so if you needed a second page, you had to copy/paste an entire page. But too many here in my office simply could not grasp it or had issues. Not to mention, the bottom of the page had our general conditions and a TOTAL BID line on every page. I want that information plus some additional room for general notes that are job specific.
So I am working on creating what I will call a expandable single page. It will have the same header/first 10 rows repeat on each page. I will make it so if you need more rows for the body of the quote, you simply copy and insert to add, or some other function to accomplish this "growing" body. So far, things seem to be working ok, though I still need to figure out if I can have the body automatically grow or add rows if I exceed the first page. But the reason I am reaching out here is the border.
We have 4 columns that form the "body" of the quote. This is where we enter the materials needed for that job. Each column has a Quantity, Model, Description and a blank column for breaking out the pricing if required. Each of those columns has a bold boarder around the entire column, not for each individual cell. Our quote form when printed looks great as a result. But now, with an expanding body where I will use the same header or top cells to repeat at each new page, I am left with no border at the bottom of the first or each subsequent page when cells are added and the body expands into a second page. How can I have the last cell of a page give me a border, but only if that last cell is within the "body" or BOM section of the quote? Is this even possible?
In other words, can I have an outline border that follows a specific number of cells, so that if cells are added, the border moves or shifts as needed to stay where it is needed?
