I have a spreadsheet that populates Column A through H via Microsoft Query.

Columns I through J are formulas using Columns A-H

Each month the query is refreshed, when refreshed the rows of A-H can expand
or contract

If the current month is 100 rows and refreshes to 105 rows, the formulas
from I-J do not copy down (nor do I expect them to)

Looking for a way for when Columns A-H change, the related columns I-J also
change.