Hey folks,
this task is a continuation of my last post https://www.mrexcel.com/forum/excel...c-formulas-dependency-tables.html#post4847911.
To give you a short summary, there are 3 dependency tables that you can see here: https://i.imgur.com/vV1obLN.png
Now the task is to make a 4th, dynamic table looking somewhat like this:
The "Take away" cells should be buttons. The idea is fairly simple: When you take away Your Mom, the production of the Computer and the Wizard is hit directly (H1). However, due to the resulting lack of the Computer, the Car production is hit next (H2). Lastly, the Dog production is hit due to the lack of the Car (H3).
Now, as an Excel beginner with little to no VBA knowledge, I don't even know where to start. I hope an enthusiastic Excel fan will stumble upon my post and take this challenge (or part of it).
Have a great day!
this task is a continuation of my last post https://www.mrexcel.com/forum/excel...c-formulas-dependency-tables.html#post4847911.
To give you a short summary, there are 3 dependency tables that you can see here: https://i.imgur.com/vV1obLN.png
Now the task is to make a 4th, dynamic table looking somewhat like this:
The "Take away" cells should be buttons. The idea is fairly simple: When you take away Your Mom, the production of the Computer and the Wizard is hit directly (H1). However, due to the resulting lack of the Computer, the Car production is hit next (H2). Lastly, the Dog production is hit due to the lack of the Car (H3).
Now, as an Excel beginner with little to no VBA knowledge, I don't even know where to start. I hope an enthusiastic Excel fan will stumble upon my post and take this challenge (or part of it).
Have a great day!