Forum Discussion
Excel Advice - Finding prohibited combinations of permissions among employees
Hello guys, From the attached table, I need to find employees (with the same name) who have the following prohibited combinations of permissions: "Credit Memo" + "Customers" "Create Vendor B...
I modified your workbook to have a Combo Task Selector drop down list:
Combo# | Task1 | Task2 |
0 | ALL | ALL |
1 | Credit Memo | Customers |
2 | Create Vendor Bills | Vendors |
3 | Make Journal Entry | Journal Approval |
4 | Check | Vendors |
To replace the report, paste the new or updated report in the FilterList Tab:
You can also update the drop down list in the ComboTaskSelectList Tab.
Let me know if you have any questions.
Cheers