If this post twice I am sorry. I tried to post earlier and I thought it posted but it didn't Anyways
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+ and sheet 3 fro the Macro. 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
I corrected the sheet to how I want it to look. Presently the Macro does NOT work