Danny_Kemp
07-02-2015, 02:35 AM
Hi,
My first post on this forum - so hi everyone!
I have some code that works really well, but I now want to add to it
and need some help!
Basically what my current code does is search an
excel database of employees, and returns the employees name, clock card ID and
their trade if 3 criteria are met (manager, boat line & team
name).
Now what I want to do is check that all employees in my excel database have been
"allocated to a team". So broadly speaking the code should take the value in B2
of the database, search in the tab where my teams have been populated:
do nothing if the it finds the value and then then search on the next value (B3, then B4 etc)
if the employee name is not found I want it to paste this name into a column, so I can then have a list of names that have not been found.
Can someone help me with the code that would do this?
Thanks
My first post on this forum - so hi everyone!
I have some code that works really well, but I now want to add to it
and need some help!
Basically what my current code does is search an
excel database of employees, and returns the employees name, clock card ID and
their trade if 3 criteria are met (manager, boat line & team
name).
Now what I want to do is check that all employees in my excel database have been
"allocated to a team". So broadly speaking the code should take the value in B2
of the database, search in the tab where my teams have been populated:
do nothing if the it finds the value and then then search on the next value (B3, then B4 etc)
if the employee name is not found I want it to paste this name into a column, so I can then have a list of names that have not been found.
Can someone help me with the code that would do this?
Thanks