Re my original posting: I works by ASSUMING(!) that history sheets are sorted
by NAME. As the "Job History" tab isn't, you will get the strange results. If
sorting by NAME is not acceptable, we will need a slightly different solution.

If there is only ONE occurrence of a name it will (appear) to work!

HTH

"cbrd" wrote:


I tried it again with different items in the history sheets. It seems to
only do this to the first two names in the drop down list. The first
person will always have one row from the second name in the drop down
list, and vice versa. Once you get to the third name in the list,
everything works well. No idea why.


--
cbrd
------------------------------------------------------------------------
cbrd's Profile: http://www.excelforum.com/member.php...o&userid=30009
View this thread: http://www.excelforum.com/showthread...hreadid=499618