I have an excel workbook with multiple sheets with the names of different countries and in each of these sheets there are permissions sets for each profiles, there are 6 such profiles. Like Canada Sheet -> Rep Profile: n number of permission sets, Manager Profile: m number of permission sets and so on.
I have to verify if all the permission sets in the sheet are assigned to the user for the specific profile and country.
Is there a way to automate this testing process? I've been doing this manually using VLOOKUP and it takes a long time and its a tedious process.