The cells in A1:A5 are dynamic and change often, but C1:F10 are always the same.
I'm looking to run a macro that will stop when the values in A1:A5 match a 5 row pattern that's in C1:F10.
For example (1 2 3 4 5) in A1:A5 does not match anything in C1:F10. I would run the macro, and it wouldnt stop until A1:A5 was (1 5 9 13 17) or (11 15 19 23 27) or (4 8 12 16 20), etc, etc.
I have a trigger already
I'm looking to run a macro that will stop when the values in A1:A5 match a 5 row pattern that's in C1:F10.
For example (1 2 3 4 5) in A1:A5 does not match anything in C1:F10. I would run the macro, and it wouldnt stop until A1:A5 was (1 5 9 13 17) or (11 15 19 23 27) or (4 8 12 16 20), etc, etc.
I have a trigger already
1 | 1 | 2 | 3 | 4 | |||||
2 | 5 | 6 | 7 | 8 | |||||
3 | 9 | 10 | 11 | 12 | |||||
4 | 13 | 14 | 15 | 16 | |||||
5 | 17 | 18 | 19 | 20 | |||||
21 | 22 | 23 | 24 | ||||||
25 | 26 | 27 | 28 | ||||||
29 | 30 | 31 | 32 | ||||||
33 | 34 | 35 | 36 | ||||||
37 | 38 | 39 | 40 |