Regression macro to work on multiple culumns

[jaja]

Hi guys,

I have a worksheet with over 8000 columns. Each column contains 5 "Y variables" and 5 "X variables". I need to regress those 5 X values on the 5 y values to find an "intercept" (or alfa) coefficient and a "X variable 1" (or beta) coefficient for each column.
Since it takes too much time to manually perform over 8000 regressions I was wondering if someone knows a solution for this problem. Maybe with a macro in combination with some sort of a loop....

I've attached a sample file with one regression in worksheet 2.


Thanks

jaja