Insert row in table after entered data

[bidsinga]

Hello,

This is my first message on this forum, so it might be unclear for you.

I got a table, some columns are variable data you have to put in by your own and I got some columns with only formulas. After entered the last variable data I want excel to add a new row with the same formulas and format as the other rows in the table.

I hope someone can help me. I don't think it is a difficult issue but I'm new with making macro's so that's why I'm asking

[AlphaFrog]

The key is to first define your worksheet range as a Table.

Here is a step-by-step guide.
How to Add Records to an Excel 2010 Table

Note: the link to Excel for Dummies is not intended as an insult. It's just a good guide. There are several others if you do a web search.

[bidsinga]

Thanks for your response. I already put the data in a table. The problem is that I'll get multiple tables below each other, so if the table automatically extend then it will overwrite the other tables.