I have 5 separate workbooks that contain lists of employee first names, and employee last names(as well as phone numbers emails etc). I want to open my workbook that contains an input box, enter an employee first name and have vba search the 5 workbooks, and if found (even a partial match, like Mitch and Mitchell) copy the entire row to the workbook that I have my input box.
Is this an attainable function for excel vba to do?