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...
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...
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...
So I have been given a task at work. Seemingly straight forward, I just can't think of the best approach.
We have a spreadsheet of users, job titles and roles assigned to them. We are trying to identify people with assigned roles that differ from the norm, but we have nothing set in stone as...
Just been to sit with the team using this form/Macro. They absolutely loved it!!!
A wise man once said....
"I think, therefore I yam."
SkipVought 25 Oct 18 12:11
Could, but thought sod it. They didn't specify don't change the form it's just my work habit, and so far no one has said a word. So I'm leaving it as is [2thumbsup]
A wise man once said....
"I think, therefore I yam."
SkipVought 25 Oct 18 12:11
Yeah that does the trick. I was just hoping to avoid adding any new columns as not my form. But we'll see if anyone shouts lol.
As always, gracias Skip!
A wise man once said....
"I think, therefore I yam."
SkipVought 25 Oct 18 12:11
Hi All!!
I have the below which does exactly what I need to do with a spreadsheet, however I have one addition to make which I can't quite suss.
To start with, the code -
Sub FilteringCP()
Dim RngOne As Range, cell As Range
Dim LastCell As Long
Dim arrList() As String, lngCnt As Long
With...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.