Need help checking bingo numbers

I am trying to expedite the process of checking bingo numbers output from a random string against a pre-made bingo card. The way this system works is I have one file with all of the random number strings associated with the name of the person each string was output for. I then have to copy and paste each string into a separate worksheet and run a macro to check and see if the person won a bingo. I was wondering if there was any way to expedite this process. For example, if I could just run a single macro to check all strings associated with a name that generated a new spreadsheet (or even a text file) detailing who won and how close the losers were. Also, I am currently experiencing an issue where the bingo checker is unclear as to where the matches have occurred (for example, the output will say "someone matched 4 on row 9 with 58," when there is no row 9).

In the Bingo Numbers workbook, I have included the bingo score card and the ways someone can win. The other workbook is the bingo checker with the macro I have been using, I have been copying and pasting in names and the individual strings then hitting run.

Here is the code:

Please Login or Register  to view this content.

Thank you for the help.

bingo checker is unclear as to where the matches have occurred (for example, the output will say "someone matched 4 on row 9 with 58," when there is no row 9)

Your code is reporting the bingo_lane, not the row because of this code:

Please Login or Register  to view this content.

and bingo_lane can be a 9.

A big flaw (I think) is that your search is looking at all of the text in a cell. So, when you use InStr for the Person X scores, it is looking at this entire text for a match:
**1**14**29**21**63**
**61**55**72**23**54**
**65**61**19**50**11**
**44**6**64**60**51**
**69**12**33**31**11**
**67**57**38**19**58**
**13**7**65**20**68**
it seems like that could report some false positives, but I am not sure what those rows truly mean (e.g. why does Person X have 7 'rows' of data while Lucky Pup only has one?).

Honestly, I am not quite sure what you are trying to achieve. I understand you have a bingo card. I'm unsure what the 5 digits are for each person, but I guess these are just randomly generated, but the bingo games I have played generally go on for more than 5 rounds. Or, do they represent the row/column/diagonal/corner of a player, but then, again, why only one for a person, since there are 11 possible ways to win. Just trying to wrap my head around your inputs and outputs.