I am trying to set up a pivot table with names horizontally and skills they have vertically. I have their email addresses in the data field. I would like to be able to select a skill and receive a list of people who have that skill, which is simple for a pivot table, but the hard part is that I would like to then send an email to the people who have that skill.
Can someone help me retrieve a list from the pivot table of only the people who match the skills so I can then have excel send out an email to that list?
Can someone help me retrieve a list from the pivot table of only the people who match the skills so I can then have excel send out an email to that list?