Recent content by Rossco82

Big sigh......... So tried that, now getting "Sub or function not defined". It highlights the "Worksheet" text, and also the first line (the sub). I had moved on a little bit, but this has put me back to square one now. Slowly losing the will with it. I went and recreated it and set all...

Hi All, I'm slightly lost with this and have had to resort to forums as I just cannot see what is wrong with the code. In short I have three tabs, Tabelle1 List of data, columns A_L. Sheet 1 A data validation set in A1 which refers to a a list of Line Managers, and a button to activate the...

String/Skip, sorry for the large delay, but I wasn't going to let this beat me. I now have a solution, all be it basic, it does exactly what I need. I'm sure you gents can make it more elegant, but I'm no where near as advanced. C2 and N2 are used for data validation pulling the headers (users...

I got exactly the conclusion I needed as it identified the "odd" assigned roles??? This would spur a whole raft of other work in the back ground. So Still don't get why that couldn't be scaled up and why more data would be needed?. In effect you have given the solution then said you can't give a...

Skip, not sure how giving you another several hundred names and roles would help?. The data sample given gives all fields and an example of the difference. What I'm asking is simply for a way to identify the differences quickly. So if it is a countif and use the low values to highlight, then...

This tells me I now need to look at the below roles : SSOS:SRGBXX:SALES_CLERK_XX SSOS:SRGBXX:SALES_CLERK_YY I can then determine if these roles are needed for a sales ledger controller. Or if someone has more/less access than they need. Once I have done that we can restrict/expand access...

Must be a Costa man lol. A wise man once said.... "I think, therefore I yam." SkipVought 25 Oct 18 12:11

You had replied by the time I did my post. Yup, thats it skip. A wise man once said.... "I think, therefore I yam." SkipVought 25 Oct 18 12:11

Unfortunately no I can't post the whole thing as it has names etc. This is why I gave a sample of the text but changed the names. Plus its 14103 rows long, do you really want all that???. System User Role Title R0P SMITH-B MCUS:BRUK:CU-FD33-03F...

Ah I see why. Its when it has been formatted on here. Look at my earlier text at 12:37 - R0P SMITH-B MCUS:BRUK:CU-FD33-03F Sales Ledger Controller R0P SMITH-B MCUS:BRUK:ZO-03SA-GB-IE-ZO20 Sales Ledger Controller R0P SMITH-B SDMS:CYGB:ALL:CLAIM_HANDLING Sales Ledger Controller R0P SMITH-B...

Not a thing, most of the text has been stripped from the roles (not sure if you did that just to test with?). But it also isn't what I'm trying to do. I can remove duplicates using the button, but the problem is that in doing so I will be editing the data. It will be filter by title/user, then...

Either way really, you would still highlight the same two lines, in which case that gives me cause to look at those roles and evaluate who is correct. It might be that the extra roles assigned are for another reason. This is why I've said anything additional is not the norm, not that either user...

Thanks! Didn't know this bit. A wise man once said.... "I think, therefore I yam." SkipVought 25 Oct 18 12:11

Hi, bit delayed, sorry. This has changed massively now anyway. I thought with the length of time it would take it was just easier to manually go and do some of the stuff required. Skip. 1. Noted. I didn't put text as the formatting went off every time I previewed it, so I used an image...

Hi Andy, This is exactly the problem. To do that is hours and hours of work. We don't want to set the standard here, this isn't our remit. We just need to identify who has excessive roles assigned to them to start with (i.e me and you do the same job, I have 6 roles you have 4, what extra two...