Goodnight I come to ask for help with a survey of cycles carried out by an employee.
In the Cycles Tab, I put the employee number in cell A3, and the VBA code will do a search on the Scale Tab from cell AI7 to cell BZ37 and count the number of times the number appears in cell A3 on the Cycles Tab and every 4 times the number found counts 1 cycle, example, 4x33= 1 cycle, 8x33=2 cycles, 12x33= 3 cycles, 16x33=5 cycles, etc.
In this example, I already put the number in the Cycles Tab in cell A3 and the employee counted 5 cycles as it appears in cell A9 of the Cycles Tab. Now I intend whenever I put a number in A3, the VBA code gives me the cycles made by that employee in A9. If the number placed in A3 of the Cycles tab does not exist, I will receive a MsgBox: "This number does not exist, please enter another number".
Whenever I put a number in A3 of the Cycles Tab, the existing data in D11 to AU 41 and in cell A9 of the Cycles Tab, must be cleared to show the data of the number that I am putting in A3. I hope I explained myself well so you understand what I mean.