Improve excel macro
Budget: €30 – €250 EUR
Keeping the same structure of current xls and macro we need the following 4 minor improvements:
• When the row contains all the relevant information to qualify the customer (industry+country) then automatically qualify him (the raw) but If information (country or industry) is missing instead of asking to input the data manually send the missing rows to another dedicated file called ToBeQualified_missing.xls with the same format of the conversion table and move forward to next row; In this way we can immediately get qualified customers instead of waiting to qualify them all by hand
• Automatically recognize all Italian Provinces and Region (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 in import (error, master etc)
• Merge the 2 current macro in one
Please see the enclosed detailed documentation and ask if something is unclear before make a quote.
• When the row contains all the relevant information to qualify the customer (industry+country) then automatically qualify him (the raw) but If information (country or industry) is missing instead of asking to input the data manually send the missing rows to another dedicated file called ToBeQualified_missing.xls with the same format of the conversion table and move forward to next row; In this way we can immediately get qualified customers instead of waiting to qualify them all by hand
• Automatically recognize all Italian Provinces and Region (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 in import (error, master etc)
• Merge the 2 current macro in one
Please see the enclosed detailed documentation and ask if something is unclear before make a quote.