I am told the guru's are here on this forum and I hope so because I am stumped and need some help.
I have a macro and need to expand some columns that I want to search. Presently I enter what I call counter numbers in 4 cells (the counters are 4 digits) The game number goes in column A, then counter digit 1 in B, digit 2 in C, digit 3 in D and digit 4 in E. I place the counter numbers I am searching for under the C1,C2,C3,C4 (HIJK) and then press find Pattern Matches. I can enter up to 12-15 rows if I like. Sometimes I only want to look for 4 rows, other times 10 so I have the ability to change what I want to look for by changing the number in N. When I press "find pattern matches" presently It will find all the location that the counter numbers are which is 4 column's. I want to be able to include some additional columns so I not only have the counter numbers but the additional columns too.
okay hope I haven't lost anyone yet LOL.I would also like to group together columns AB,AC,AD,AE,AF,AG,AH,AI,AJ like on sheet G-G+. Once it finds the counters it places the information on sheet 2. I have several different sheets to look through and each sheet has over 40,000 rows on counter numbers I will be needing to search through
Let me know if you have any questions and I REALLY appreciate your help
https://www.dropbox.com/s/cxa4xpvh2pvgsof/Pattern%20Search%20Bingo.xlsm
https://www.dropbox.com/s/q8hg844sbyh313i/G-G%2B.xlsx
I have a macro and need to expand some columns that I want to search. Presently I enter what I call counter numbers in 4 cells (the counters are 4 digits) The game number goes in column A, then counter digit 1 in B, digit 2 in C, digit 3 in D and digit 4 in E. I place the counter numbers I am searching for under the C1,C2,C3,C4 (HIJK) and then press find Pattern Matches. I can enter up to 12-15 rows if I like. Sometimes I only want to look for 4 rows, other times 10 so I have the ability to change what I want to look for by changing the number in N. When I press "find pattern matches" presently It will find all the location that the counter numbers are which is 4 column's. I want to be able to include some additional columns so I not only have the counter numbers but the additional columns too.
okay hope I haven't lost anyone yet LOL.I would also like to group together columns AB,AC,AD,AE,AF,AG,AH,AI,AJ like on sheet G-G+. Once it finds the counters it places the information on sheet 2. I have several different sheets to look through and each sheet has over 40,000 rows on counter numbers I will be needing to search through
Let me know if you have any questions and I REALLY appreciate your help
https://www.dropbox.com/s/cxa4xpvh2pvgsof/Pattern%20Search%20Bingo.xlsm
https://www.dropbox.com/s/q8hg844sbyh313i/G-G%2B.xlsx