Here is my dilemma.
1.
I have a document where the first page is a static set of rows and columns. Basically updated once and then with the exception of changing percentages remains the same where as all the same rows and columns need to print. That seems pretty straight forward. Set a print area of that range. This is the "original contract" section.
2.
I have on the second (or more) page(s) of this document a range of cells that from month to month can change. Mostly just get larger as months progress. This is called "Change Orders" section. This section has a dynamic list of entries that total at the bottom in a sub total and final cost line.
My goal is to have the following happen. I would like to have the first page print out the same each time From $A$1:$F$42.
Then a dynamic range between cells $A$44:$F$118 with only cells that have an entry in Column A being captured.
And finally the last two lines of the spreadsheet $A$119:$F$120 at the end of the document regardless of how many entries are in the dynamic range.
Reason being is from month to month I need to copy and past the previous months entries into tabs (which I deleted for this exercise) but the document will have 12 tabs for each month that link previous data to one another.
This sheet has a few macros for hiding and unhiding column D, as well as an unprotect sheet, insert row below, copy formulas, and re-protect sheet macro.
Can anyone guide me in combining all these things before I go crazy!!..
Thank you
Bookmarks