Results 1 to 9 of 9

Need multiple macro buttons to insert new, formatted rows

Threaded View

  1. #1
    Registered User
    Join Date
    04-04-2014
    Location
    Oregon
    MS-Off Ver
    MS 365 Enterprise
    Posts
    29

    Need multiple macro buttons to insert new, formatted rows

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to Insert Rows with Buttons
    By Cardan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-21-2013, 05:06 PM
  2. How can I insert multiple sets of option buttons (radio buttons) in Excel 2010?
    By mickwooduclan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2013, 10:01 AM
  3. Macro Buttons to Insert Rows
    By gusibay2000 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2012, 10:34 PM
  4. Insert rows via values of formatted cell
    By christya24 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2009, 10:52 AM
  5. Macro to insert formatted rows
    By oneblueaugust in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-24-2009, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1