Identify and number Patterns

  • Re: Identify and number Patterns


    Can someone please help me with this. I am getting further and further behind at work trying to figure out code at this point. I am learning at a slow pace and this will help speed things up for me tremendously. Thank you all!!!


    I want it to be displayed like this example:
    [ATTACH=CONFIG]57651[/ATTACH]Not like this:


    [ATTACH=CONFIG]57652[/ATTACH]

  • Re: Identify and number Patterns


    The data comes from a statistical analysis of number inputs from a robot I'm trying to sort this data for positioning The names of the files are bogus for fun lol Being able to sort the data this way will allow me to find the positioning quicker What is here is the far right hand column of The robot code and a piece from the far left. All in all has nothing to do with sorting anything besides this. I will use this kinda like a pirate would use a map to find his buried treasure lol


    what do you suggest? I'm all ears. I'm going cross eyed filtering this stuff manually lol. I really do appreciate your help. I'm just frustrated is all and working around the clock "literally" to come up with a solution plus everyday life lol. I spoke to the local college today and they do not offer excelerator classes. Only basics so no MACRO classes so learning has been slow. It's a good lesson going through all the language and code but need help lol


    No no more columns That picture was a page that I copied and pasted from numerous filtered counter numbers There are only 6 total columns.

  • Re: Identify and number Patterns


    Quote from pike;692655

    Hi
    there is plenty of good notes in the vba help
    in the module highlight "AutoFilter" and click the F1 Function button
    The limitation will be with the loop .. and a break in the code to to change the data ..VBA doesnt work that way.


    Just watched your Video ..so you would like to find the Pattern , of four numbers across the row/columns, so you can edit the next five rows?


    I can not use my F function keys. I have a new Toshiba laptop and it does allow this. It turns my sound up and down for example, not a short cut key

  • Re: Identify and number Patterns


    That surely is when you press fn+f1, try highlighting and press f1 alone.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Re: Identify and number Patterns


    Quote from KjBox;692866

    That surely is when you press fn+f1, try highlighting and press f1 alone.


    Thanks Kj that worked! Can you help with my Macro?


    This is what I get when I click on F1


    Dim Worksheet1 As Worksheet Dim returnValue As AutoFilter returnValue = Worksheet1.AutoFilter

  • Re: Identify and number Patterns


    Read Pike's instructions again, then follow them, pressing f1 will bring up a help window explaing how to use AutoFilter

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Re: Identify and number Patterns


    I did follow his instructions and read what it said but it does not help me write the code i need. When I pushed help, it brought up 2 items.

  • Re: Identify and number Patterns


    How do I add more rows to sort with this code? I am new to this and far from an expert with code and need help. If not here than perhaps another forum?


    Code
    Sub simple_search()
        Cells.Find(What:=Range("B3").Value & "^" & Range("C3").Value & "^" & Range("D3").Value & "^" & Range("E3").Value, After:=ActiveCell, LookIn:=xlValues, LookAt:= _
            xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
            , SearchFormat:=False).Activate
       
    End Sub
  • Re: Identify and number Patterns


    zipped is 43 mb and it will not upload. You can use the ne you have been using it is basically the same. Once I download it I can just copy and paste additional rows to that sheet

  • Re: Identify and number Patterns


    Dude
    my last attempt
    three buttons click the "Run Find" button First then "Reset" Button then the "Find Next" Button
    then just use "Reset" Button and then the "Find Next" Button
    best i can do


  • Re: Identify and number Patterns


    pike,


    I REALLY appreciate your help, I sincerely do and the last thing I want to do is upset anyone and I also appreciate your patience. The question I have is ..... is it possible to find the entire group like I want to do or is that impossible. This is finding one at a time which is good and quicker than what I have by a long shot so THANK YOU!!!! Just curious if what I am asking can be done which is to find say rows 1-8 all at once all together?

  • Re: Identify and number Patterns


    and how do I change the range to look all the way to 500,000 rows, it stops after only about 20 rows. Thanks Pike, I mean that. This wil save me a lot of time and maybe I can come home early one afternoon and give the wife a date night. You hae no idea the hours I have been putting in finishing this project

  • Re: Identify and number Patterns


    Quote from pike;692895

    have you had a look at the last attachment ?.. any thing is possible if you invest the time..


    yes, I have , I must be missing something. I will re examine

  • Re: Identify and number Patterns


    Okay I have looked at the attached and downloaded it. I did a quick entry of another 2000 rows. I changed the range to go down to 2000 rows and it does, BUT, if i put in say 2222 to look for it, it will find the first 2222 then it , then I click find next and it finds a completely different number?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!