I have been out of the world of creating macros for about 4 plus years and am trying to create one that will delete the contents of a row and then enter the word the user name from the cell above this row down to the row and then then next 3 cells enter the word TOTAL and then a sum formula in the next 2 cells.