I do not know if this can be done in excel, without VB
I am an average user of excel but by no means an expert in formula
I have a number of cells that change value when i press F9 to refresh
What i want excel to do each time i press F9 is to grab the results and store them in sequence in another worksheet line by line.
The manual way is to
Press f9, Copy the data in the cells switch to the Results worksheet sheet Paste Results,
Go back press f9 (New Results) copy results reopen results worksheet and paste resuts below the last results.
And so on
I want excel to create the results in the "Results whorsheet" for me (The data on the Results Worksheet would grow every time i press F9 )
Thanks for any Advice
Regards
Richard
Bookmarks