Hello Everyone,
I am still trying to work this out but without much success... A friend showed me a trick with Evaluate Function which seemed promissing, but I wasn't able to make it work with some longer and more complex formulas which use matrix references and functions combined.
I am almost...
Dear all,
I have worked on a model file that might help to show what I want to achieve.
In the file there are 3 sheets, the first two will bring data from another sheet through power query.
1st sheet: Data that define kinds of projects and their aspects.
2nd sheet: Data that define formating...
What a good idea this formulas translator is! quite often have to work in my projects from my personal computer which runs English Excel 2016 version, while my office runs with a Portuguese 2013, tell me about version and language problems!! hahaha
I will surelly take some time to check it more...
Thank you for your feedback SirJB7 !! I was afraid that would be the case that my workbooks are quite full and probably seem quite messy... Sorry for that... haha
I am worried also about the fact that string formulas in tblFórmulas are in PT-BR format, and being so, even though your Portuguese...
You sound like someone who would be able to help me with my crazy Power Query and Formulas stuff!! haha
The best thing is your Brazilian, so would you know how to fix the dam dates formating when using vba and cells values?? haha
Nice to see a fellow Brazilian in here!! :)
Hi SirJB7!
Thank you for the reply! I had read some of the material for new users yesterday, and took the time to read some more today just now before writing this reply :)
I thought about uploading a file, but the files I was working with had quite a lot of confidential information, as well as...
Hello Everyone! Greetings from Sao Paulo, Brazil
My name is Didson New, and I work coording regulatory projects of products certification. I am a passionate Excel user, people here call my workbooks systems "dilsonilhas", a mix of my name and spread sheets... lol
Excel has enabled me to keep...
Hello everyone,
It is my first experience with forums, and from what I have seen here in other posts, I am really hopefull someone will be able to help me on my task.
I have a table of dynamic formulas in string format, some of them are array formulas, brought through Power Query to this...