4 Improvements to excel macros

We are using 2 macros stored in [login to view URL] to import raw data (leads) coming from a Linkedin Scraper Program stored in [login to view URL] Macros manipulate these data, performing some operations in order to get the proper format: - look for duplicate records email/linkedin_id and homonimy - automatic fill country code using complex xls function - look for completeness of all rows: they must have industry, country code After that second macro put columns in proper order for an ERP import and returns another file called [login to view URL] We need 4 improvements 2 Majors: A. When the raw has all the relevant information to qualify the customer (industry+country) then automatically qualify him (the raw). If information is missing instead of asking in the macro these data put the row in another dedicated file called [login to view URL] with the same format of the conversion table and move forward; In this way we can separate the workflows and immediately get qualified customers B. Add a column to conversion_table and to_be_qualified called standard_role this role must be categorized comparing title and headline (with a proper algorithm) using standard role table enclosed to this document. Please note that this role may be manually changed later by the operator 2 Minors Automatically recognize all Italian Provinces (look for all Italian Provinces in Address) all Italian Provinces must have Country:=Italy and country code IT Make automatic recognition of file type from the name (error, master etc)