Simple Excel function. Script to run multiple iterations of a sheet and record the data

I have a sheet with a simple macro to randomize a sequence of returns, and display the results. There is a button to run the macro once, and only one macro in the sheet. The results I want to record are in F4:T4 Here is the sheet: [login to view URL]

I want a simple script to run this simulation repeatedly (I would select the number of times, likely 50-1000, collecting each set of results as a new row on the another tab. I'd like a header section on the new tab that is showing me some statistical analysis of these results - average obviously, but maybe a couple other simple analysis as well Median? Std Dev? (not too worried about that part, and I could add those later). Main thing is the script to run these sheet multiple times and display the results.

I think this is a very simple job, just would like someone to whip it up for me

Compétences : Excel, Python, Statistiques, Visual Basic

en voir plus : iterative calculation excel, how to auto populate in excel from another worksheet, enable iterative calculation excel 2016, excel autofill formula, excel autofill cell based on another, timestamp in excel that doesn't change, excel formula timestamp when cell changes, iterative calculation excel 2016, can vba script run outside excel, simple excel vba script, excel web script sheet, script run excel macro, script create multiple accounts using excel file, excel vba automatically run script, mysql run multiple script files, verify sheet name exists excel using script, script create multiple users excel, macro script read multiple cells excel, mysql script run multiple scripts, schedule vbs script run excel macro specific time day

Concernant l'employeur :
( 17 commentaires ) Dartmouth, Canada

Nº du projet : #19769836

Décerné à:


Hello, I am proficient with Excel and VBA. I would love to help with this project. Please contact me for more information.

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(139 Commentaires)

8 freelance font une offre moyenne de $24 pour ce travail


Hi, How are you? I am very interest in your project. As I am a professional Expert with great experience and skills, I am sure that I can help you I'm ready to start to work on your project right now. If we clarif Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(12 Commentaires)

Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately :) Br

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(23 Commentaires)

Dear Client, I am Expert in Excel Macro. I have 5+ Years of Experience in Data Entry, Web Scrapping, Web Research and MS Office. I will be there during your working hours to provide support whenever you need. Let’s Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(7 Commentaires)

Hi, glad to bid on your project. I have 7+ years experience of c/C++ development and also VB. It is not difficult for me to help you. I wish your good response for me. If you choose me, I will complete it successfu Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)

Hello! I would absolutely love to do this project. As I have no work to do these days, I can start immediately and finish as soon as possible. I can assure you of a 100% accuracy, as I am very patient. This would be a Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)

Good time of the day, Sir! I would like to apply for the project. My Portfolio: - Gyroscope Health -innovative app, written using react native, that tracks your health, food, sleeping habbits. (DM for URL) - Startup Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)

PROFESSIONAL SUMMARY ــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــ Trustworthy Accountant With over 8 years Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)