2

I'd like to know how to add a new row copying all formulas from previous row ..

What I'm looking for is as follows

 SR. NO     ITEM CODE       DESCRIPTION       UNIT COST
     1       5463345       (A V-LOOKUP)     (A V-LOOKUP)       [ADD BUTTON]

     2 

By pressing the Add button will create a new row with Sr. No 2 (automatic) and copy all the formulas from previous row with a new add button .

I know how to create a button(drawing) and attach script only thing is don't know what the script is to be :( There is also another submit button in this page which will take all these data into a newly created sheet (so far success) Entering the item code will thus add all the required values.

marked as duplicate by Jacob Jan Tuinstra, jonsca Mar 6 '16 at 8:17

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.