+ Reply to Thread
Results 1 to 1 of 1

Macro to insert row/section with button

  1. #1
    Registered User
    Join Date
    09-19-2019
    Location
    USA
    MS-Off Ver
    Office 2016
    Posts
    1

    Macro to insert row/section with button

    Hello,

    I am new to programming, but have been tasked with revamping a budget form that will be used across a wide variety of projects that can vary in size. I initally added plenty of additional rows to account for the larger projects and then kept them hidden for the smaller projects, but I am not sure that will be the best option going forward.

    I have started looking at the possibility of adding buttons to each section that would effectively allow the budget to expand to accomodate each project, but I am struggling with working out the code. I thought I had it figured out, but then realized that if I use the buttons at the top, then the later buttons do not insert rows in the correct location.

    For the "Income" section I would like to copy the row below the button, and then just insert it at the top of the section so the formatting and formulas carry over. Same with the "Expenses" area, expect I need to copy/insert the entire section (rows 25-33) so all the line items are duplicated as well.

    Any guidance?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 08-30-2017, 01:52 PM
  2. Replies: 3
    Last Post: 09-24-2015, 06:46 AM
  3. Replies: 30
    Last Post: 11-06-2013, 12:43 PM
  4. Button (or Macro) to insert a row
    By raza_m33hdy in forum Excel General
    Replies: 2
    Last Post: 10-17-2011, 12:42 PM
  5. Insert a line in excelsheet in some section
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-19-2011, 07:59 AM
  6. INSERT NEW ROW MACRO BUTTON
    By guillaumet in forum Excel General
    Replies: 1
    Last Post: 11-21-2005, 11:10 PM
  7. Insert Row before Macro Button
    By Kieranz in forum Excel General
    Replies: 2
    Last Post: 09-30-2005, 08:57 AM

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