MenuReview.xlsxI need to compare system access for our users against a master reference listing that each employee should have based on their position. If you review the attached excel file you'll see a tab called 'masterlist' and a tab 'store314'. The master list contains each position within the company. Each position requires certain system menus, and options within those menus that are accessible only by providing the user with a security key. In the example, I shows an accounts payable clerk that should have the menu "AP" and security keys "invoice", "rev", etc. On the store314 tab, it shows an actual accounts payable clerk with the right menu but the wrong security keys.

I'm trying to wrap my mind around the best approach to take in reviewing hundreds of users across multiple sites, all referencing the same master list of menus and keys based on the position. So my real working file has the one master list, and 10 different tabs and each tab lists users/menus/keys for their respective sites.

Is this something that can be compared using VBA or would I be better served trying to dump it in sql and doing the comparison there?

The end product needs to be a report that shows each user and the wrong menu/keys they posses. Thanks for any guidance!