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

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

i have spreadsheet has "customer details" section, , user enters info , able clear button etc. problem is, can't seem figure out how save information, ie, re-create whole row sheet2, because row copies uses =cell contents cell in 1 row.

how go copying row, moving downwards one? not copying formula, formulas output, have looked @ pastespecial can't seem work either.

for wondering, used this:

range("c38:p38").select selection.copy sheets("sheet2").select sheets("sheet2").cells(rows.count, "a").end(xlup).offset(1, 0).pastespecial paste:=xlpastevalues, operation:=xlnone sheets("sheet1").select

which selects range want copied in first line, copies, goes sheet 2, pastes 1 row downwards every time , sheet 1.

excel vba excel-vba