Matcharray

[wix111]

I am trying to design an excel spreadsheet which can do this

First: A pop up box for user to enter a long sequence of 2-digit numbers. Each number has a code assigned to it. I have already finished this conversion using VLookUp.

Then, the program will pick the second input number, known as the MARKER. It will then check if the subsequent 6 inputs below this marker number matches their corresponding Code Pattern, in order from a seperate datasheet FixedArray. Once match, the program will return a textbox indicating "Match found on PatternNumberxxx" and will skip 2 rows of input before assigning the new Marker to check for for new set of matching pattern.

FixedArray

[TABLE="width: 500"]
<tbody>[TR]
[TD]Marker[/TD]
[TD]Pattern1[/TD]
[TD]Pattern2[/TD]
[TD]Pattern3[/TD]
[TD]Pattern4[/TD]
[TD]Pattern5[/TD]
[TD]Pattern6[/TD]
[/TR]
[TR]
[TD]01[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]02[/TD]
[TD]X[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]A[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD]03[/TD]
[TD]C[/TD]
[TD]F[/TD]
[TD]B[/TD]
[TD]A[/TD]
[TD]F[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]..[/TD]
[TD]..[/TD]
[TD]..[/TD]
[TD]..[/TD]
[TD]..[/TD]
[TD]..[/TD]
[TD]..[/TD]
[/TR]
[TR]
[TD]99[/TD]
[TD]B[/TD]
[TD]D[/TD]
[TD]F[/TD]
[TD]A[/TD]
[TD]I[/TD]
[TD]E[/TD]
[/TR]
</tbody>[/TABLE]


If none of matches are found, it will return with an indication to the user "no match at all after 6 patterns"
It then it skips 4 rows before starting testing on new Marker Number.

The cycle repeats as user input new numbers.

Any help in this will be much appreciated!