Using Solver Multiple Times In One Sheet

Hi forumers,

I am working on a sheet in Excel 2007 currently. My work utilises the Solver Add-In to solve an optimisation problem I have. The sheet is set up with a list of companies in column A. In the other columns, I have a range of financial variables for each company. I use these variables to solve an optimisation problem for each company - this requires using the solver multiple times in the same sheet.

I have set up solver to solve the problem for the first company. However, I would like to copy the solver formula over all companies. (I am solving for the variables called V and σA in the attached sheet). Can this be done without having to individually set the constraints and target cell for every row?

I have attached my sheet for your information. The appropriate solver routine is applied in row 2.

Thankyou for taking the time to read this post. Any help you may be able to provide is much appreciated

Apologies, just eager to get a reply!