Thanks for the response Jim. I too think the VLOOKUP works for the
comparison of values, but the second piece is where I'm stumped

"and when they match, copy and paste the corresponding user name from
Worksheet B to Worksheet A adjacent to the appropriate position #."

Thanks for the help.


--
leecone
------------------------------------------------------------------------
leecone's Profile: http://www.excelforum.com/member.php...o&userid=31833
View this thread: http://www.excelforum.com/showthread...hreadid=515556