So I currently have an excel "master" workbook that contains a long column of attributes associated with a person's name
Ex:
First Name Last Name Job Title City of assignment Utilization - Jan Utilization - Feb
Bob Dole Artist Denver

I have a 2nd worksheet with the information setup like this
Ex:
Name Days worked
Bob Dole 28

I have 800 names on each of these tables and I need a macro to search the 2nd worksheet find the name (even though it's not an identical match) and copy the days worked and put it in the utilization tab. The names necessarily won't be in the same order every time. I need to do this every month and make it fairly user-friendly. Any ideas guys??