Hello,\n\n\nBeen 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.\n\nI have attached a sample file that, in its essence, is the same as the template I am working on.\n\nData 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.\n\nWhat 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.\n\nTo 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)).\n\nI hope that made sense.\n\nOnto 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?)\n\n\nI 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 [Blocked Image: https:\/\/www.excelforum.com\/images\/smilies\/smile.gif].