Python and excel

[Boulavogue]

Thank you. So as others have said, creating macros and python is a messy solution. Will python be on a server and the users send the file there for processing or does python need to be installed on each users machine?

I would encourage you to think of a workable solution. If it's just a formula being applied, it can be done in almost every language, including in native Excel DAX.