|The Randbetween formulas are used to generate a variety of different possible percentages (the equivalent of rolling dice), then there are dozens of depentent cells that generate calculations based upon the random numbers and data in other workbooks. |
C4=a perscribed numeric value
Often times I will need to copy the values from the 20th row and paste them into D29:D39 running total, without loosing sight of the value that had been gernerated simultaneously in D1.
Basically, I need cells D4 to R13 to generate numbers "on command", but I would like all other cells in all other worksheets to autocalculate as usual.
Does this help?