Automatic Auto Fill
 

Is there a way to automotically auto fill formulas down a column when the
data next to it extends? I have data in columns to the left that will
periodically get longer and I want the formulas next to the data to extend
with the data automatically after I refresh the data query (from microsoft
query).