Not being a VBA expert, I hoping someone can help me. I've found several examples of things that are close but I haven't been able to modifiy anything to work.

Here's what I have -

In A4:T4 I have columns with calculations to perform and that I need to repeat on multiple rows based on the value in B2.

In other words, If I have the value "5" in B2, then I want to copy A4:T4 and paste it 5 times, on the following rows A5:T5,A6:T6,A7:T7,A8:T8,A9:T9,A10:T10

It would be nice if it would also clear the added rows when I change the number in B2 so if I went from 5 to 2, I wouldn't end up with clutter. I can have as many as 100 rows in this spreadsheet.