This coding was provided by "XLD", thanks Bob. Follow this VBAExpress thread http://www.vbaexpress.com/forum/showthread.php?t=18645 to get an idea of what the coding is suppose to do. The glitch comes up when player 3's number, 33, is entered into cell C29. The number 33 should've gone into cell N36, but instead it went into cell AO37. What is odd is that players 1 and 2 numbers went into their correct cells and the rest of the coding seems to be working correctly. It's "My Bad" for not checking the original coding in the attached VBAExpress thread that Bob provided. The error with the coding shows up in the original thread too.
Best regards,
Charlie