How do I create a dynamic formula on Excel?
- by Mario Marinato -br-
On Excel, I have a DDE formula on B1 which reads =server|info!someText.data
I want to change the formula so that someText is written on A1 and then reference it on the DDE formula. Something like =server|info!A1.data.
I have tried to concatenate "A1" directly on the formula, as it is above, with no success.
Some other things I tried were =server|info!A1&".data" and =server|info!indirect(A1)&".data", but had no success.
Is there a way to achieve this? How?