I have 3 columns
A - Equivalent to "Machine Name"
B - Equivalent to "OT Number"
C - Equivalent to "Responsible Technician"
I would like to know if it is possible to create a procedure that when the user inserts the "OT Number" the procedure looks in column B if there is already an "OT Number" in a specific spreadsheet ("Machine_Registers") and if there is a message to the user saying that the number already exists
PS: They all have an "Unknown" value because I just had the idea of the procedure recently
A - Equivalent to "Machine Name"
B - Equivalent to "OT Number"
C - Equivalent to "Responsible Technician"
I would like to know if it is possible to create a procedure that when the user inserts the "OT Number" the procedure looks in column B if there is already an "OT Number" in a specific spreadsheet ("Machine_Registers") and if there is a message to the user saying that the number already exists
PS: They all have an "Unknown" value because I just had the idea of the procedure recently
