Hi, is it possible to program a macro which will automatically populate the next row of formulas on the sheet (copying the row or range above) when the user inputs data into a cell which is in the row above the one to be populated?

In other words I have a sheet which I have populated 300 rows with formulas, they are using an IF function to appear blank until a user uses them. But they take up a lot of space, and it will eventually be neccersary to have over 300 rows. Is there any way for the rows which are populated with formulas to grow with the data using a macro or similar?

I hope this makes sense

Thanks