Create an xls macro to manipulate a datasheet
Budget: €30 – €250 EUR
- We need a macro to process raw data coming from a Linkedin Scraper Program - these data are stored in Master_Organization_YYMMDD.csv; (we will import daily)
-Macro shall manipulate data in order to import only relevant fields (yellow) in a new import_organization_YYMMDD.xls and standardize industry with a lookup:
ST1 Check for duplicate record linkedin_id –no duplicate record in import!
all duplicated records must follow in another worksheer called duplicatedrecords
ST2 Set Industry standard –using the current look-up formula
ST3 check missing fields
If company name is missing import in a new file > ToBeQualified_Name
If the category is missing import in a new file > ToBeQualified_category
If headcount is missing import in a new file > ToBeQualified_Headcount
ST4 tranfer data in a new worksheet import_organization_YYMMDD.xls
-Macro shall manipulate data in order to import only relevant fields (yellow) in a new import_organization_YYMMDD.xls and standardize industry with a lookup:
ST1 Check for duplicate record linkedin_id –no duplicate record in import!
all duplicated records must follow in another worksheer called duplicatedrecords
ST2 Set Industry standard –using the current look-up formula
ST3 check missing fields
If company name is missing import in a new file > ToBeQualified_Name
If the category is missing import in a new file > ToBeQualified_category
If headcount is missing import in a new file > ToBeQualified_Headcount
ST4 tranfer data in a new worksheet import_organization_YYMMDD.xls