I am trying to convert an old paper form to Excel and am a novice at best with VBA. I am wondering if anyone can help me figure out the code to automatically sum up the total of the various columns in the below spreadsheet. The user inputs the number of rows needed when they open the work book but I can't seem to figure out how to get the various columns to subtotal in row 10 based on the number of rows they input. Any help/advice would be greatly appreciated! Thank you. JG