Hello everybody,

Im trying to create an email distribution list creator, if you will.

In the rows I listed the email adresses and in the columns you have the distribution list that they can be included in. I want a string of data (or Concatenate) to show up on the the second sheet based on whether the distro column had an "x" in the email row. The goal is to be able to copy the cell in the populating sheet and just be aple to paste the string in to the "to:" box when I am sending an email. I listed three emails and three distribution lists as an example, I actually have around 200 individuals that I need to include and a total of about 30 Distribution list for different scenarios. I want to be able to change the email address and the distro list reflect the change because of the frequency that individuals move in and out of their positions.

Distro Matrix example.xlsx

Thank you very much for your time!!