excel solver
Hi,
I should apply the solver function a lot of times and I'd need to know if exist a function that make me able, once I've set the solver up, to obtain the estimated coefficient of the regression (the output of the solver) for each month of a my temporal series without change every time the cells. Is there a function? or I've to use VB. In that case how con i build this macro? I hope you have understand what I mean, cause I'm not English, and someone can give me help. Thanks. Bye |
excel solver
You would have to use VBA. Turn on the macro recorder (Tools | Macro
Record new macro...), go through the steps to set up Solver and solve the problem for one month, and turn off the macro recorder. Share the code you get in this newsgroup (in the text of a message) and indicate how the data for multple months are laid out. Someone should be able to generalize the code for multiple months. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Hi, I should apply the solver function a lot of times and I'd need to know if exist a function that make me able, once I've set the solver up, to obtain the estimated coefficient of the regression (the output of the solver) for each month of a my temporal series without change every time the cells. Is there a function? or I've to use VB. In that case how con i build this macro? I hope you have understand what I mean, cause I'm not English, and someone can give me help. Thanks. Bye |
All times are GMT +1. The time now is 08:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com