I'd love some advice on how to accomplish the following.
I have an application that I'm training users on how to use it. When it comes to creating new users, my admin users want a simple way to determine what role they should assign to new users.
I have created a matrix of available user roles and the permissions each role has in the application. What I'd like to create is a "checkbox" type Excel workbook that allows my admin users to select the permissions they want a new user to have and then have Excel spit out "Hey, based on your selections, you should assign the XXXX role for the new user."
How do I accomplish this in Excel?
JimG
