Hi everyone! I have a spreadsheet for work that has a number of rows of data starting at row 1. In this example I have data in rows 1-118 and the total of the data is in row 121. I have created a userform that inputs the data for me. However every time prior to using the userform I have to manually insert more rows after row 118 so that I don't run out of room before my total line. What I would like is for a new row to be inserted after my last row of data BUT before my total line every time I open the userform I have created. Does this make sense?
Bill
Bill