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...