Automatically ppulate the next row of formulas?

[B00105904]

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

[royUK]

This can be automatic, depends on your Excel version. Update your user profile

[B00105904]

Update my profile? Sorry where can I do that?

I use Excel 2007

Thanks

[royUK]

To update your Profile see the drop down when you click on your name in a post.

Take a look at Excel 2007 Lists

[B00105904]

Done, thanks...


I will read that link you gave me!

[B00105904]

Thank you royUK.

This is very close to what I want but unfortunately it does not seem to carry the formulas when I do this? I want it to copy formulas down.

i.e. if I had dates in column A and amounts in column B, then when these values are there, columns C, D, E and F are automatically populated by formulas?

[B00105904]

(Without the formulas having to be present in the cells before hand)

[royUK]

If the formulas are in the previous row then as new data is added to the List the formulas will populate