I currently have a workbook where on one sheet you can choose two options form two drop downs. After these are chosen, another sheet reads this and performs an hlookup to pull the correct data from a data dump sheet. I then have formulas to do the calculations for r^2, slope, and intercept already. On my sheet with the drop downs you can choose any combination and it will show you the r^2, slope, and intercept and automatically changes when i change the drop down.

The problem:
Each drop down box has 44 options and I need to obtain the r^2, slope, and intercept for every combination between the two (1936 to be exact).
How can I get excel to pull the right data, populate, then calculate for each possible combination without having to copy everything each time.

I currently am selecting the two inputs from the drop downs, copying the output of R^2 and all, then performing it again for another combination.