excel - Copy a row from sheet 1 to sheet 2 with a button -

I have a spreadsheet that has a "customer details" section, and the user enters his or her information and cleans it Is capable of a button etc. The only problem is I do not have to figure out how to save that information, i.e., copy the entire line in sheet 2, mainly because this line copies from the use = cell to get content from any other cell All in one row.

How would I go about copying that line, then going down one? But if the formula is not copied, I would like to produce sources, I have seen the last time, but this can not be done to do this work.

To think of anyone, I have used it:

 < Code> range ("C38: P38"). Choose. Copy Sheet ("Sheet 2"). "Sheet 2"). Room (rows.kount, "A"). End (XLEP). Offset (1, 0). Paste Special Paste: = XLPist Value, Operation: = xlNone Sheets ("Sheet1").  

Selects the threshold you want to copy in the first line, then copies sheet goes to 2, paste it every time 1 times and back to Sheet 1.