If you don't want a DV List what about a DV Custom formula, eg

=MATCH(A1,People,0)

Change A1 to the DV / input cell, 'People' is a named range or cell ref of
the list of names (could be a dynamic name). Set Input message and Error
alert to suit.

Regards,
Peter T

"PD" wrote in message
...
To assist with office management, I need a VB script or excel macro that
does
not allow input in a defined column if the data being input is not listed
on
another column.

For ex: the file has a sheet marked Operator Name, which lists names of
all
the staff members. The other sheet is an input sheet which requires us to
input the name of the staff and their performance details.

I need a VB script/excel solution that does not allow the inputter to
input
a name that is not listed on sheet marked Operator Name. (Data validation
or
List would not be appropriate as the team size is large and the inoutter
will
have to scroll through a huge list of names).

Also, if I am not being too greedy, could it be possible for the script to
mention the closest possible name available on the Operator Name sheet in
case the inputter mis-spells the name.

Thank you for your assistance.
Regards,

PD.