Hi. I have tinkered with this project and have exhausted all attempts to solve one feature. I assume you will know the rules of a Sudoku puzzle. The main work area is D5:L13 and numbers entered there are repeated in Z6:AP22. Because of this, the sheet has to be protected. The small board is used for standard puzzles and the large for fiendish ones. The object I am seeking is for, say, 8 is entered in D5 and appears in Z6. I would like the red 1,8 & 9 to auto delete and the 4 1's to clear if they equal D5 or Z6.Before going any further, I imagine there's a potential 81 macros involved. If so, would that be too many or slow the sheet significantly? I currently delete the red numbers manually, but as I am timing myself I I would like an automatic solution, if one is possible. I have included the workbook so you can see how the sheet functions. If you ener 5 in D5 you will see what happens. Changing D5 to 8 you will see is a better number to enter. Thank you for any help you can offer.
Very sorry, protection (no password) must have set before the send performed. All references have been deleted so test 2 should open correctly.