Identify and number Patterns

Re: Identify and number Patterns

okay, thanks Pike or all you have done in helping I do appreciate it your time. I hope you have a Happy Thanksgiving!

Re: Identify and number Patterns

I will try in a few, need to get at least an hour sleep LOL get up in two hrs to go to work LOL Thanks again

Re: Identify and number Patterns

okay, I copied this macro and pasted it in a new module? correct> I then dragged down column K. I clicked on fnd next and it did not find the same counter number. It finds a different one. Did I do this correctly?

Re: Identify and number Patterns

Quote from snb;692920

or ?

Code

Sub simple_search()
   Rows(5).Resize(Columns(11).Find(Join([transpose(transpose(B3:E3))], "^"), , xlValues, xlWhole).Row - 5).Hidden = True
   Rows(Columns(11).Find(Join([transpose(transpose(B3:E3))], "^"), , xlValues, xlWhole).Row + 1).Resize(50).Hidden = True
End Sub

I need some direction...sry...newbie here, do i delete what Pike suggest? Do i add this to his on the same page? different page? Thaks

Re: Identify and number Patterns

Here is short video that may shed some light. I finally uploaded the video. I noticed that the location number is different in the video. they have to be the same. When I did this quickly I did not copy and paste. Instead It got dragged it down making it count 1,2,3,4,5,6, if there is any confusion on that part. The rest of the video is what I am looking for.

https://www.youtube.com/watch?v=ZuzYCKSWv9M

Re: Identify and number Patterns

Quote from snb;692938

why do you think did I use the same name for this macro ?

I have no clue, as i said i am a newbie. What exactly do i need to do please?

Re: Identify and number Patterns

Quote from larbec;692943

I have no clue, as i said i am a newbie. What exactly do i need to do please?

Thanks for the suggestion and I will go to Barnes and Noble and/or Library. In the meantime can anyone help me with this? That is why I came to the forum t get assistance from the Guru's

Re: Identify and number Patterns

Not quite pike. I needed to make sure when I get my return search they are sequential. Meaning if I had 10 different locations all named something else They would all have the numbers 1,2,3,4,5,6,7,8,9,10 but different location My answer after scan needs to match "location" and be sequential ie.... Location Cat 1, Cat 2, Cat 3. Not. cat 1, Dog 2, Cat 3

Re: Identify and number Patterns

pike

i appreciate all you've done. I went to the book store and bought VBA for dummies and excel for genius'. I wrote a helper program and it's doing EXACTLY what I want and the complete scan takes less than 10 seconds. Have a Happy Thanksgiving.

Re: Identify and number Patterns

The cats and dogs was like a widget. Sometimes we get hung up and make things more complicated than they were. That's why I said early on my "internal" program has nothing to do with what I am wanting to do

Sub ertert()
Dim x: Application.ScreenUpdating = False
ActiveSheet.AutoFilterMode = False
Range("O4").CurrentRegion.ClearContents
x = Application.Transpose(Range("F3:F10"))
With Range("A12").CurrentRegion
'.Columns(7).FormulaR1C1 = "=RC[-5]&RC[-4]&RC[-3]&RC[-2]"
.AutoFilter 7, x, 7
.Copy Range("O4")
.AutoFilter
End With
Application.ScreenUpdating = True
End Sub

[ATTACH=CONFIG]57695[/ATTACH]

And absolutely. My gratitude to Pike for hanging in there and not giving up on me. I have been up for the past two days working on this. Ya'll have no idea how this has made my job a lot easier and I was determined to compete it . Pike THANK YOU THANK YOU THANK YOU!!!

For others ..... telling me to go buy a book is not helping anyone at the present, it helps for the future but when ppl come here for assistance, they should get direction and go buy a book IMHO is not direction. Pike pushed me to learn and I Thank him for that BUT, he also gave me suggestions and did not give up. What gratitude and respect I have for him (Pike) !!!!!!!!!!!

Re: Identify and number Patterns

Quote from snb;693164

So you finally got a solution from Nilem ?

Nilem?