Hi, I am new to EXCEL VBA and have got a question on the usage of it.
I have a dataset containing a lot of missing values. I actually computed the linear regression for 2 variables to impute the missing data.
I would like to ask if there is any way that I can use VBA to help me automatically fill the data with regression equation of a cell under, say, column A, with the respective value under column B.
For example, the linear regression is y=0.7x+10
I have a missing data on cell B7, I would like to impute B7 with 0.7(cell C7)+10. And then repetitively do the same thing for the column A till it meets, say, cell B100.
Is there any way that I can use VBA to carry it out? Thank you!!