Hi all
Hope someone can help!
In Column C (starting in Row 2) I enter a code (This will always start with "POR_" followed by 5 numbers"
In the Mechanics tab I have the codes and the product names (In columns AA:AB)
I have an INDEX MATCH set up, however, new Products/IDs are set up every day, and the form will be sent out weekly, with the updated data in the "Mechanics" tab
However, if someone tries to enter a code not found on the tab, is there a way I can have it set up so it can either be overwritten (when not found only), or a pop up box asking for a value if not found)
I appreciate I could just leave the cell unprotected, and can be overwritten if required, just would like a bit of protection that a correct value cannot be overwritten
Hope that makes sense!
Hope someone can help!
In Column C (starting in Row 2) I enter a code (This will always start with "POR_" followed by 5 numbers"
In the Mechanics tab I have the codes and the product names (In columns AA:AB)
I have an INDEX MATCH set up, however, new Products/IDs are set up every day, and the form will be sent out weekly, with the updated data in the "Mechanics" tab
However, if someone tries to enter a code not found on the tab, is there a way I can have it set up so it can either be overwritten (when not found only), or a pop up box asking for a value if not found)
I appreciate I could just leave the cell unprotected, and can be overwritten if required, just would like a bit of protection that a correct value cannot be overwritten
Hope that makes sense!