Auto add formulas to new rows

[G1032]

Hi
I have a sheet that imports data from a website.
New data each day added to top row of sheet 1
Sheet 2 is used for calculations from the data on sheet 1.
I have sheet 2 formulas copied down to row 5000.
When I refresh the workbook and import new data each day sheet 2 gets auto populated with new data also. However the cells containing formulas at the bottom rows of sheet 2 don't auto update.

The question - How to I get the formulas to auto fill correctly down all rows of sheet do after new data is added to it? I have a macro set to do this but I'm looking for an automatic solution.

I thought putting the data in a table format would work but it didn't

 

[Joe4]

BOOM! Thanks. That works now. You're a gent.
One last question on this if you have time? Is it possible to call that macro after background query has run as opposed to after a certain a time delay? I only ask because in the event of a slow internet connection or slow processing power the macro will run before the query has run?

I don't know. I have never tried anything like that.
That would be a topic for a new question.

 

[G1032]

I don't know. I have never tried anything like that.
That would be a topic for a new question.

Perfect. Thanks a million for all your help

 

[Joe4]

You are welcome.