Hi There,

I have worksheet that uses a validation list as the source for various lookup functions, the end result is a dynamic report, I now intended to email this out automatically, I already have the code to create an email and attach the data in the body. However as the data is sensitive I need the data to be emailed to one person, per entry in the validation list - again all this has been coded correctly, in that when I manually select an entry the appropriate data is refreshed and an email generated with the correct recipient.

Unfortunately i'm having a little mental block on how to go each item within the validation list, as there are currently 400 entries (set to grow), its quite a laborious process (albeit even now still faster than the previous method used).

For reference purposes the validation list exists in a sheet named "STATEMENT" and CELL D2

any help would be greatly received, thank you.