I have a named cell "newhire" and two named tables "interview" and
"employee", containing identically formatted rows of contact info stored
alphabetically by last name. Vlookup works great for viewing individual info,
but I need help in writing a macro to automatically find and move a hiree row
from my "interview" contact table to my 'employee" contact table, keeping the
tables sorted.

Sure appreciate your help. -John