** MS EXCEL MACRO / VB small project **

Please run the attached MS Excel Spreadsheet. What I would like is the following: 1.) If you run this macro investment spreadsheet (say 500 trials), you will see that it calculates average returns as a percentage of total trials and an average time frame of the investment. I would like to put in two fields in the spreadsheet area of (minimum investment time frame and maximum investment time frame) so that the randomizer picks random time frame investments which are all within this min / max time frame. This way I could specify 1 - 20 years and would be certain that there would be no trials that had 30 or 40 years in them in the final report results. Actually this min/max could also be offered in the macro tool so that it is first seen as the spreadsheet is loaded and its entry goes into the underlying spreadsheet. 2.) If you look at cells J25 - J31 you will notice that the spreadsheet uses a beta value of 1.5. I put in a changeable beta field in cell B2 which is currently set to 1.5. IF I change B2 it will change all of the beta values in column F. This also affects the results of the report. The only thing it does not change in the report is the beta values in the report on the left hand side: such as: Senario 1: Market up, Fund > 1.5 (this refers to a 1.5 beta, but if I had changed the beta value in B2 to 2.00 then maybe the report should show: Senario 1: Market up, Fund > 2.0 Is there any way we can get it to reference B2 so that as soon as B2 changes the report changes appropriately for all senario's and uses the new beta numbers to ensure that if the Market is UP, Fund > 2.0 then only trials with leverage coeffients (betas) greater then 2.0 will be in those trials. *** Actually, I would like the macro at the beginning of the spreadsheet scenario to allow one to type in the beta value they want which will go into B2 and calculate everyhing in column F based on the beta value entered in the initial macro settings. This way the beta can be changed without having to close and re-open the spreadsheet and get into the B2 cell and change it there. 3.) Please give me full documenation as to how you made each of the changes requested above in a MS word document so that I can understand it clearly and ensure the integrity of the final data in the report by fully understanding what has changed. If you need a password it is either: rosebud ROSEBUD -David ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows 2000 Professional MS Office XP