i have a table A as follows




Id C1 C2 C3 C4 C5 C6 C7 C8 C9 C10 C11 C12 C13 C14

1 2 3 2 5 1 2 3 2 5 1 2 3 2 5
2 2 4 6 2 2 7 4 6 2 2 7 4 6 2
3 3 3 8 3 3 3 3 8 3 3 3 3 8 3
4 3 5 3 4 9 1 9 8 3 3 3 3 8 3
5 4 4 3 2 4 3 4 3 4 4 3 4 3 4
6 5 5 1 4 5 4 4 3 2 6 5 5 1 1


I need a vba code to select all patterns in my database such as when 2 on top, followed by 2 at bottom column-wise(2 LAPPING 2). Afterwards, I want the code to select the next row below the identified patterns, ie After the identified pattern, what data comes next? : IN THIS INSTANCE ONLY id3 WILL BE SELECTED because only column one (C1) contains the pattern.

Id C1 C2 C3 C4 C5 C6 C7 C8 C9 C10 C11 C12 C13 C14
3 3 3 8 3 3 3 3 8 3 3 3 3 8 3




I hope I am clear with my problem enough. I am very new to coding!!!

ThanksPattern Datatable.PNG