adding cell = macro not working

[w_lred]

Ok, I had a working macro before i added an extra row for another entry (No. of Hours spent). The entire data collection calculates the total price of a project (called PSR) in another cell underneath. The macro is suppose to move the entire data into another sheet to keep a history (in Sheet2). I've attached the file containing the workbook. I appreciate the help.

[StephenR]

It's xlUp, not x1Up.

Please Login or Register  to view this content.

[w_lred]

lol. of course. thank you.