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:
Bookmarks