Write a VBA program that will step through the range named CostScenarios, taking each value, setting the range VCost equal to that value. That updates the range (a single cell) named Profit. Then we want to put profit in the range MyProfit in the same row as the corresponding cost in CostScenarios. We will also compute Break Even volume in Col E using Goal Seek. This program mimics the functionality of a Data Table. Also write another subroutine that will clear the computed MyProfit and Break Even values. Create form control buttons to run the subroutines as you see in the video.

Question 3 - What is the profit before tax if the variable cost goes changes? Question 3 - What is the profit before tax if the variable cost goes changes