Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.
Weekly Challenge
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Macro
Big thanks to EMEA's Filip R at JLL for your explanation.
good challenge😀
Spoiler
Conceptually not too difficult. used the information in the post about file formats as a lookup. Had a few issues with running my batch macro. I think because I lacked a tool following it, it was only running for the initial record to save disk space. Either way when I put tools to follow it (browse then the tools to sum the value fields) it took a while to run but seemingly calculated correctly.
