VBA to fill table with results of all variable combinations in separate calculation module

Hi,

I tried to search the forum for possible solutions but my search returns too many threads. I'm looking for help to create a macro which would calculate all the results of combinations of values from two columns in a calculation module and fill the table with the results. See attached workbook, which is a simplified version to make it easier to understand.

In range B6:C8 I have a calculation module, which calculates the charge (C8) based on the selected month (C6) and rate plan (C7). I use vlookup formula to determine the number of days and multiply by the daily rate based on the plan.

In colums K and L, I have listed all possible combinations of Months and Rate Plans. I'd like to find out how I can run all these combinations in the calculation module and complete column M with the result of each combination.

Many thanks for your assistance.

Thank you for reaching out.

As stated, this is a simplified version. In reality I have much more variables in the calculation module (and some of them are linked to other sheets) and over 3000 combinations. I can't solve this with a formula and try to find a way to calculate the outcome of every combination and store it as a value in column M. If somebody could help me with this, then I could apply the technique to my spreadsheet.

Bump, no response.

Any VBA specialist out there who could help me with this?

Hello VBA wizzards Is my request not clear enough or too difficult?