I hava a validation list in A9 that drives some calculations which outcome
need to be put in a different sheet.

How can I loop thru every single element of the validation list and select
it so it shows in A9?
Thanks in advance