populate list with each new value

I have a file with 3 spreadsheet and one called "parameters" with list for data validation purposes.

I would like that each time a new value is entered in column 2 of one of the three other sheets (in my example, the code is under "H&M" sheeet), a macro goes to "parameters", column 5, look if the new value exists in the list, if yes nothing, if no, add the new value, and sort the list alphabetically before going back to initial sheet.

My problem is the .find code to look into "parameters", range E., i get a "type mismatch" error.

Can someone help?

It works perfectly, i amend it in order to perform the macro if a new value is entered in column 2 of any of the first 3 sheets of the workbook ( or "H&M&, or "crew health" or "A&I P&I"),

Is there a way that when it add the new value in sheet "parameters" column 5 , it does it as per "parameters" format, without adding a new step copying the format?

cause it add it but as per initial sheet format (ex in red center) while in "parameters" it's in black

adapting Bakerman's code

Please Login or Register  to view this content.

thank you so much all works perfectly