I wish this was as simple as it sounds, but I have so many "exceptions" (for lack of a better term) that I have no idea how to set this up. I've attached an example spreadsheet that hopefully helps clarify my explanations.
I need to have a button for each seciton that will insert a new set of rows, properly formatted so the user can just fill in the blank. For instance, under the "Wages - Form W-2s" section, lets say the user completes the first row (cell D8) and has another to add. We need a button that will add both the row to fill in as well as the spacer row (like row 9). One of the conditions here is that it needs to add the new rows just above the "Check here if additional documents included that are not listed above" row (like row 10).
I need a separate button for every section on the form that behaves in this manner. Another "exception" is that all of the buttons need to stay in place and not move down the sheet with the addition of rows. They should each be placed either to the far right (preferred) or far left of the page, AND (another exception) should not print when the sheet is printed.
And if all that wasn't enough, the second page showing to the right of the first page (the Internal Use Only Side) should expand down, page for page, that the ones on the left do, which as you can see from the example is not currently happening.
Ugh! I feel like I'm asking for a miracle, and maybe I really am, but really hoping a miracle worker sees this and has some help for me!
Thanks
Bookmarks