Ok, here's the situation. I have a worksheet that is a master list of all employees with certain employee attributes in one worksheet. In another worksheet, I want to paste a list of employees with some other employee attribute, and then have it find those employees in the master employee worksheet and copy over certain bits of info from that row into this smaller subset worksheet.

For example:

Master worksheet - each row contains Employee name, department, office #, and SSN.

Working sheet - I paste in employee name, manager name.

It then finds each row in the master where the name matches, and grabs department and office# and copies them to the adjacent cells.