here i would add rows in sheet1 every time fill data in userform witout effect on values cells in my case it supposes add rows aftera row19 with show the value in the rows(subtotal,total) with lastrow does adding because the rows(subtotal,total) link the last row contains data