Need help with a Macro to run Regression.

See attached for file.

I need to run a regression with column C as the Y variable, and column BM as the X variable. Then, I need to repeat this with column C continuing as the Y variable, and column BN as the X variable, and so on.

Then I need to repeat the above with Column D as the Y variable, and columns BM - CJ as the X variables (but run them one at a time NOT a multiple regression).

I also need to name the sheets with the regression outputs with a concatenation of cell C5 and cell bm5, then c5 and cell bn5, etc. OR, If its possible, put all the Y variable regression outputs in the same sheet, named cell c5, d5, e5, etc.

Here is the code I have so far, but can't seem to get the rest. Thanks in advance:

Please Login or Register  to view this content.

Hi

Make sure you have a sheet in your workbook called sheet2 and then try

Please Login or Register  to view this content.

rylo