Running solver for many cells

Hi

I am trying to solve around 1000 cells at the same time. I came to know that this is possible by using macro but I have been unsuccessful to implement it.
I need the solution from AC3:AC1003, the constraints and formulas are already there. So I need to move to the next row after solving each one.
Another problem is that a part of the variables will be shared by all. So if I get a optimised value for the AC3 cell , when i get the optimised value for AC4 , AC3 value gets changed. I figured this can be fixed if I add a macro after each solve to copy its text value to another cell.

Can anyone help ? Thanks in advance