I have two workbooks which contains a list of names, id, issues- multiple
type of issues in this column, master record date, issue begin date and issue
end date . One workbook contains only records with a specific issue end date
(A) and the other contains records with issue dates >the specific issue end
date (B).

I need to distinguish the name/id of people who have the specific issue in A
who do not have a record for the specific issue in B.

example
Sally Smith has Issue 1 enddate in workbook A, but does not have an issue
start date for Issue 1 in workbook B

Is there an easy way to compare these? I am currently trying to match the
records by hand but there are 4000 records in each workbook.

Thank you in advance