J
JRobertson
I have two spreadsheets that are updated monthly. The first shee
contains a list of authorized employees (name, ID number, dates o
employment). The second is an extract from security badge readers
containing names, badge IDs, and door numbers for all transactions.
need to compare the names from the badge transactions to the list o
authorized employees and generate a separate listing of exceptions
Those would be contractors or service personnel that need to b
authorized for each individual visit.
How can I automate this process and have the non-employee names show u
in a table or separate column?
Additionally, is there an easy way to copy the transactions for al
non-employees into a separate sheet that I can forward to security fo
validation against front desk sign-in and maintenance records
contains a list of authorized employees (name, ID number, dates o
employment). The second is an extract from security badge readers
containing names, badge IDs, and door numbers for all transactions.
need to compare the names from the badge transactions to the list o
authorized employees and generate a separate listing of exceptions
Those would be contractors or service personnel that need to b
authorized for each individual visit.
How can I automate this process and have the non-employee names show u
in a table or separate column?
Additionally, is there an easy way to copy the transactions for al
non-employees into a separate sheet that I can forward to security fo
validation against front desk sign-in and maintenance records