I am new to VBA and don't have much experience in creating code, however what
I am trying to do I have seen in other people's excel sheets, but they were
password protected and so I couldn't look at them. Here is what I am trying
to do:

I have a cell, say "A1" that requires an input. There is a set of equations
in a table in the same excel spreadsheet. When the input is entered, say
"5", and then a button is pressed, the 5 rows are added to the table and the
equations are copied down.

So I think I need an if statement based on the "A1" input. Or should this
be a loop statement.

Thanks in advance for any help on this.