the best alternatvie autofill formula/VBA when a new data is updated

[coding123456]

Hi Everyone,

I have a data set which is from AFO, which is SAP Analysis for Microsoft Office in a sheet. I have a ranged of formula at the end of the column. I need the formula to autofill itselfs whenever the AFO is refreshed.

1. I tried range dynamic array it works but my file became very huge
2. I convert to table but my formula will not able to autofill the formulaonce the AFO is refreshed.

Any advice?

 

[stigcorneer]

If you import the data from AFO to excel via Power Query you can add formulas to the result table after writing it to a table in your workbook.