Converting raw data into data table

[Damian37]

Hi all,
I would like to convert some raw data I have into a data table in order to have my formulas within my worksheet auto-populate whenever a new line of data is added to the worksheet. I tried to highlight all of the existing data and convert it to a table, but when I add a new line into the worksheet, none of my formulas copy down. Essentially, columns B - M are empty cells for the user to enter in data, and columns N - X are all formulas. Any help is greatly appreciated. Thanks!

Damian 37

[Pauleyb]

For each column from N-X, copy the formula from the top row of the table, then delete the formulas in that column, then paste the formula back into the top row. The formula should then auto-populate all the way to the bottom of the table and any new rows added to the table will have the formula, too.