VB/Excel query
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. |
VB/Excel query
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. |
All times are GMT +1. The time now is 11:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com