Macro to group autofilter up to 8 rows

[Larbec]

I am trying to sort 8 rows of data and extract it from 500,000 rows. This is one example of 8 rows that I would want to sort


Example of Counter Locations.jpg


You will notice that it has a game number in "column 1", location in column six 6, and 4 four numbers in columns 2-3-4-5 that we will call counter numbers. When I run the filters I want to be able to find a group of the numbers that look like that above. How can I set up a MACRO to find similar groups of numbers like this?
.
Patterns rows 1-8.jpg

I have tried to get help from another forum without much success http//:ozgrid.com/forum/showthread.php?t173361andgoto=post

[:) Sixthsense :)]

Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

[Larbec]

Here is a short video of kinda what I want to do

http://youtu.be/ipjzHGXuAY8

[Larbec]

Here is a sample worksheet with the exception on the sheet it will find one counter number (4 digit number) st s time. I want to find all of them as a group of numbers from one location. They actually form a pattern when form the one location

[nilem]

Hi Larbec,
try this (with helper columns)

Please Login or Register  to view this content.

[Larbec]

man, I almost wanna hug ya LOL, This is looking fantastic, What I need to change if possible is when I click to search, I do not want to mix locations. The number/patterns needs to come from the same location(s) If there are not enough numbers to complete the pattern(s) thats okay, just let it display what it can...does that make sense? Maybe I can do a short video

[nilem]

may be a small example file

[Larbec]

https://www.dropbox.com/s/fspwyhe7sx...r%20MACRO.xlsm



The file is too large to post and when I shrink it, its useless lol. I am using drop box. Feel free to change whatever you want with it as I have the original plus it does not do what I need it to do. Maybe you can make some changes and I can re download it. I have to get at least an hour sleep as I get up in 2 hours to go to work LOL BUT, I need to finish this too as its driving me crazy and this will save me a lot of time.... A LOT of time. I will not keep this up long but ling enough for you to do what you need to

[nilem]

Still not entirely clear.
If you need the data only in one location, what location you are interested?
Show the desired result in a small example.

[Larbec]

It is like you read my mind nilem. I made a few changes to your sheet. If we could incorporate your sheet with mine it would be perfect. Let me know if this makes sense to you?

[Larbec]

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 I dragged it down making it count 1,2,3,4,5,6, LOL sry 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

[nilem]

In your file example I saw the result, which is returned by the macro.
But show a result that you need

[Larbec]

I'm not sure I understand what you mean? Guess I will see. do what you think needs to happen and i will take a look at it Thank You!!!

[Larbec]

Have you had an opportunity to do any more work on this?