I am automating a project management task list for my boss. I have input boxes for project, client, department, responsibility, due date, etc. He wants a check on the input that is sort of a cross between autofill and data validation. For example, if the client is “GA Power” and they are already on the list for another project, he wants to start typing “G…” and have it know to put in “GA Power” instead of “Ga Power” based on previous, non-contiguous rows. Also, he’d like to enter “Georgia Power” and have it know to change it to “GA Power.”
A dropdown list would eliminate the autofill issue, but I don’t think data validation will work because there is a possibility of new clients. The only solution I can think of is to put a client master list in the file for data validation, and instruct the team to enter new client names before adding them to the task list. (This would be needed for at least half the columns in the file.)
Any other thoughts or suggestions? Thanks!!
A dropdown list would eliminate the autofill issue, but I don’t think data validation will work because there is a possibility of new clients. The only solution I can think of is to put a client master list in the file for data validation, and instruct the team to enter new client names before adding them to the task list. (This would be needed for at least half the columns in the file.)
Any other thoughts or suggestions? Thanks!!
