Have a look in VBA help index for FINDNEXT. There is a good example you can
modify.

--
Don Guillett
SalesAid Software

"DNA" wrote in message
lkaboutsoftware.com...
I'm sure this will be a Macro:

I have several sheets with a workbook that contain part numbers. If a
part number = X, then place an employee number in the next column directly
beside the part number column.

NOTE: Part numbers vary from column to column throughout the work book.

Thanks for your help!!