Okay, I tried to do this myself, but I am completly new to Excel VBA coding and what my supervisor wants me to do is way beyond what I can do on my own, so I think I may be trying to eat the whole elephant </SPAN>in one bite.
I am trying to do is compare to lists of names in the same workbook
Sheet 1 has all the names for each employee in a cell range (A:A). Sheet 2 has the ticket info with the names of anyone who worked on it in a ";" sperated list for example john smith;guy thomas in another cell range (B:B)
What I want to do is have a function I can add in =timeson() that will count each time a guys name shows up and prints the number in the cell the function is entered in an empty cell.
I am trying to do is compare to lists of names in the same workbook
Sheet 1 has all the names for each employee in a cell range (A:A). Sheet 2 has the ticket info with the names of anyone who worked on it in a ";" sperated list for example john smith;guy thomas in another cell range (B:B)
What I want to do is have a function I can add in =timeson() that will count each time a guys name shows up and prints the number in the cell the function is entered in an empty cell.