Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Rossco82

    Filtering and e-mailing result

    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...
  2. Rossco82

    Filtering and e-mailing result

    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...
  3. Rossco82

    General thoughts/advice

    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...
  4. Rossco82

    General thoughts/advice

    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...
  5. Rossco82

    General thoughts/advice

    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...
  6. Rossco82

    General thoughts/advice

    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...
  7. Rossco82

    General thoughts/advice

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

    General thoughts/advice

    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
  9. Rossco82

    General thoughts/advice

    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...
  10. Rossco82

    General thoughts/advice

    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...
  11. Rossco82

    General thoughts/advice

    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...
  12. Rossco82

    General thoughts/advice

    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...
  13. Rossco82

    General thoughts/advice

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

    General thoughts/advice

    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...
  15. Rossco82

    General thoughts/advice

    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...
  16. Rossco82

    General thoughts/advice

    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...
  17. Rossco82

    How to exclude results from list within another sheet

    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
  18. Rossco82

    How to exclude results from list within another sheet

    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
  19. Rossco82

    How to exclude results from list within another sheet

    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
  20. Rossco82

    How to exclude results from list within another sheet

    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...

Part and Inventory Search

Back
Top