Thank you so much for your help.
I have tried the “Clicker” and it works just great.
Per the attachment, you can see the “Clicker” work.
As each number is “Clicked”, the sheet calculates the Standard Deviation.
For the 1st number Clicked which is number 4 and it is shown in Cell A5. The Standard Deviations (SD) for # 4 and all other numbers are shown in Cells EE5 to FO5.
What I need help to do is to put each SD in the SD Columns I2 to I19 and K2 to K20. So after #4 is Clicked those columns would show the SD in Cells EE5 to FO5.
When the next number is clicked, # 22, SD Columns I2 TO i19 AND k2 TO k20 will show the SD in Cells EE6 to FO6. Etc.
Hope I made myself clear and again thanks for all your help.
Cheers
Nick
Bookmarks