coding123456
New Member
- Joined
- Feb 11, 2025
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
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?
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?