G
Guest
I have a formula which calculates different values every time the workbook is
re-calculated, as this formula references a cell which uses the RAND()
function.
Is it possible to capture each value and have it be populated in a separate
table?
I'm assuming that, if possible, this entails using a macro, however, if it
helps, here's the formula in question: =(SUM(D4:E4,A1:C4)*SUM(A1:E4))^D4
B2 contains the RAND() function.
re-calculated, as this formula references a cell which uses the RAND()
function.
Is it possible to capture each value and have it be populated in a separate
table?
I'm assuming that, if possible, this entails using a macro, however, if it
helps, here's the formula in question: =(SUM(D4:E4,A1:C4)*SUM(A1:E4))^D4
B2 contains the RAND() function.