Thanks for the clarifications.
Try this slightly modified version.
End Sub[/code]
Try and visualise workbook 1(unchecked for issues) as employees id’s that your boss’s wishes to come to a future venue that he’s tasked you to organise, then picture Workbook2 as holding all of the company’s employees id’s who have ever had or still have issues with other employees id’s or multiple employees id’s (the multiple peoples Id’s are all stuck within the free text along with the details of why’s and who’s) unchecked of course for issues.
How would you set about sending out the invitations?
More importantly, how could you be 100 % confident that within the small list of employees(Workbook1-list) that your boss gave you, that nobody on this list has an issue with another employee on that same list (Workbook1-list)?
The only way to know is to go through workbook2 and filter for only those on the small list employees(Workbook1-list), and see if then go through the free text of the filtered and check if they are also on the invites.
Manually, well that would be fine if it were 100 or 200 being asked to the event, but not practicle.
Take the following scenario:
John has an issue with more than one person and the people he has these issues with are all in that “ one row of data”True”! well we need the id’s of these people, but only if they are on the small list
John = A1234567 who has issues with the following .Andy B1234567 .Mike C1234567. Tam D1234567(freetext)
Your code still seems to only get John = A1234567 <>with Andy B123456 and does not get John = A1234567 <>with Mike C1234567 or / and John = A1234567 <> with Tam D1234567
Remember John has an issue with all three people(ids) and these people are also on the small list(invitee's) who need to be rescheduled to a later date(some other event where john will not be at)
Does this make sense. So its works for the first hit but not the rest
So at the event, Mike and Tam will beat the crap out of John! As we never picked that up.