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

Are you able to help?

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

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

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?

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

I have shorten the file to 83kb and zipped . It is still not allowing me to upload it

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?