Excel Goal Seek challenge

[Sorin_Markov]

Hello, hope you are doing great!

Please could someone help me?
I'm struggling to create a workflow that uses a macro to automate this function called Goal Seek, I've basically already downloaded all the examples here from the community and tried to edit it to make it closer to my case, but with no success.
In the attachment is the logic of my task, I put it very simplified, but the idea would be to change a variable A given an equality between other variables, B1 and B2, respectively, with B1 being directly derived from A.

 

[Christina_H · Accepted solution]

If I've understood this correctly, this is just maths not macros.

Excel formula for price: =M7/(P7*J7-P7-J7+1)

In Alteryx: [Expenses]/([CM target]*[VAT rate]-[CM target]-[VAT rate]+1)

[Sorin_Markov]

Perfect thank you!!!