save multiple "calculate now" scenarios to a log

Dear Excel Geniuses:

I've got a complex spreadsheet which uses random numbers to simulate multiple outcomes.

I've attached a sample workbook (without the underlying formulas) which shows:

Four "input cells": B2, B3, B4, and B5

And six "results" cells: C2 thru C7

I need a macro which will automatically "copy and paste" (virtually or otherwise) the contents of these cells into a table (which you see on the tab labeled "Trial Log" which has x rows and 10 columns (one column per variable above).

And can the macro also take care of the tedious repetitive "calculate now" function, perhaps with a 2 second interval?

I've got very limited experience with macros so feel free to talk to me like I'm an idiot!

Please Login or Register  to view this content.

Try that, you will need to adjust column G to show you a %.

Please Login or Register  to view this content.