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.