+ Reply to Thread
Results 1 to 2 of 2

VBA to insert multiple new lines in table with specific functions

  1. #1
    Registered User
    Join Date
    03-05-2020
    Location
    Midlands, England
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2

    Question VBA to insert multiple new lines in table with specific functions

    Hello,

    Been using the forum for a while to find all my VBA related query solutions and been pretty successful so far. However, I am in a process of working on an increasingly complex template and with my limited knowledge of excel and VBA - need some of the Guru's help.

    I have attached a sample file that, in its essence, is the same as the template I am working on.
    Data is produced by a system and copied - everything from column A to column L and columns O, P, Q and R are manual and has some formulas in.

    What I want is a button on the sheet that, when clicked, adds a new line in each of the tasks (above each "Total" in column C) - ideally I'd want the new lines to also have formulas that other lines in columns P, Q & R have.
    To make it even more annoying, in an ideal world I'd like the newly added lines to give an option of selecting the employee from the same list that the vlookup is referring to in the Rates table column. (e.g. 3 new lines are added in the existing table providing an option of some sort to select, which employee to add (the same for all three lines)).

    I hope that made sense.

    Onto Problem number 2 - I have tried to look, but can't seem to find a solution that works for me. I need a quick an easy way to Add up the totals within the table for each task. e.g O19 should =sum(O14:O18) and R19=sum(R14:R18). Usually once I paste the system data, there are hundreds of lines so I am trying to find a good way to automate these calculations (perhaps another button that can be used once the inside data has been manipulated as needed and ready to total up?)

    I hope this makes sense but definitely let me know, if I can clarify some things up and huge thanks in advance, I really appreciate any help and time anyone is willing to spend replying .
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-05-2020
    Location
    Midlands, England
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2

    Re: VBA to insert multiple new lines in table with specific functions

    Is anybody here able to help?

+ 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. [SOLVED] Insert multiple lines between each row
    By karstens in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-15-2019, 01:46 PM
  2. [SOLVED] How do I insert high-low lines on 2 specific lines (out of 4)?
    By radiotower in forum Excel General
    Replies: 0
    Last Post: 01-20-2017, 02:20 AM
  3. [SOLVED] insert multiple new lines in one go, at every second row
    By edunne in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-07-2014, 06:04 AM
  4. VBA on specific lines in table
    By angel2903 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2014, 06:03 AM
  5. Replies: 1
    Last Post: 08-25-2010, 09:45 AM
  6. [SOLVED] table - lines variables for DB functions, charts.. etc..
    By Marina Limeira in forum Excel General
    Replies: 1
    Last Post: 01-21-2006, 03:35 AM
  7. [SOLVED] data table - lines variables for DB functions, charts.. etc..
    By Marina Limeira in forum Excel General
    Replies: 0
    Last Post: 01-20-2006, 05:20 PM

Tags for this Thread

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