This is my first post so I hope I have the protocol etc correct ....
I am administering an event that about 30 people are attending. I'm accepting scores of payments each month from various sources, each payment assigned to a specific participant.
I have a Workbook with two Worksheets, Participants and Payments. I export details of all the payments into the latter.
I want to be able, for each row in Participants, send the participant all the rows in Payments that relate to him/her.
So in the example, I want to email to Tony Woodcock at a at b.com rows 1 and 4 from the Payments sheet; and to Amelia Earhart rows 2 and 3 (preferable all with a standard wrapper explaining what it all is).
Is this possible in Excel (or anything else?!).
All inspiration gratefully accepted.
Thanks
N
Bookmarks