Still not clear what you want. If desired you may send to the address BELOW
a SMALL workbook example and I will take a look. With that make a CLEAR
explanation of what you want as I will not go back to this thread to look at
the problem.

--
Don Guillett
SalesAid Software

"DNA" wrote in message
lkaboutsoftware.com...
It doesn't appear that FINDNEXT would be the choice I should use.

I want one macro that searches all worksheets, and if it finds a part
number of 54789, then put employee number 005 in the column directly
beside the part number. This way when one value is entered, it populates
the entire workbook.

Hope this makes sense.