VBA code to copy formula down table

[ExcelFailure]

Good Morning,

I have a microsoft query data table that updates itself every minute. The table has formulas in. When the table updates itself and adds new rows in the table for new data, the formulas do not copy down to these news rows automatically.

How can I do this please?

[mikeTRON]

Do you already have a code to add to or are you starting from scratch?

Can you post a sample workbook so we can see where the formulas are?

[ExcelFailure]

I got the following code from another poster, but it didn't seem to work properly, just made Excel crash:

Private Sub Worksheet_Change(ByVal Target As Range)
LR = Cells(Rows.Count, 1).End(xlUp).Row
PR = Cells(Rows.Count, 7).End(xlUp).Row
Range("G" & PR & ":I" & PR).Copy Range("G" & LR & ":I" & LR)
End Sub