Hi all!,
Quick question: So im trying to create a financial model that uses the rand() and randbetween() functions to put in randomised growth rates for certain parameters for a company. Ive successfully set up the functions and output but i want to quick record the output each time I press F9 to randomize the growth rates. Is there a way I can save each F9 output without having to copy paste it each time?
Alternatively, i can duplicate the model across many excel sheet tabs and collect the outputs in a single sheet so it reduces the number of copy pastes required but a more efficient way would be much preferred.
Many thanks
Quick question: So im trying to create a financial model that uses the rand() and randbetween() functions to put in randomised growth rates for certain parameters for a company. Ive successfully set up the functions and output but i want to quick record the output each time I press F9 to randomize the growth rates. Is there a way I can save each F9 output without having to copy paste it each time?
Alternatively, i can duplicate the model across many excel sheet tabs and collect the outputs in a single sheet so it reduces the number of copy pastes required but a more efficient way would be much preferred.
Many thanks