Hello
I introduce data in a form like sheet (Form_1), such as the name of the Product, the Type of analysis, Date of analysis, etc.. That data is linked to a unique value, a numeric value (CoA number). I use a macro to put that data in another sheet (Table_1) which is a table with all the entries that were made in Form_1.
My question is, how can i avoid to submit data in Form_1 which would duplicate data in Table_1. The intention, if possible, is to compare the unique number (CoA number) when I click the macro button to submite the data in Form_1 with the one´s that already are in the table_1.
Many thanks in advance
I introduce data in a form like sheet (Form_1), such as the name of the Product, the Type of analysis, Date of analysis, etc.. That data is linked to a unique value, a numeric value (CoA number). I use a macro to put that data in another sheet (Table_1) which is a table with all the entries that were made in Form_1.
My question is, how can i avoid to submit data in Form_1 which would duplicate data in Table_1. The intention, if possible, is to compare the unique number (CoA number) when I click the macro button to submite the data in Form_1 with the one´s that already are in the table_1.
Many thanks in advance
