VB/Excel query

[PD]

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.

 

[Peter T]

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