Create an xls or small desktop application to process spreadsheet
€8-30 EUR
Paid on delivery
Background
- We are qualifying several contacts using a linkedin scaper tool, wich generate a file [login to view URL] generally on a monthly base (ATT1)
- This file need to be processed using [login to view URL] (ATT2) in order to be entered in crm
- After processing sys need to return an output named [login to view URL] (ATT3)
Features and steps
The process will consist of the following steps:
- Look in the current Master table and add new records (rows import) only if the following conditions are met:
o The member_id D is not already present -if already present return an error message put in a new spreadsheet
o The email L is not already present -if already present return an error message put in a new spreadsheet
o If there are fields (rows) with same name N and surname O highlight the mas potential double entries or homonyms
- Add new columns to the Master Table using Conversion Table
o Add column X Country using current formula and if some country is missing ask the operator to addi t manually before importing the row
o Add column Y Industry_std using current formula and if some industry_std is missing ask the operator to addi it manually before importing the row
o Add column AC Status using current formula
- Select only relevant columns from Conversion Table and insert the new records into [login to view URL]
Project ID: #34231620
About the project
16 freelancers are bidding on average €48 for this job
"Sir, MAcro VBA Coding is my field and I am an Excel VBA and Coding Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with more More
Hello Sir/ Ma’am A skilled full stack developer, I have rich experience in JAVA,C, C++, C#, Python, .NET , MYSQL, SQL, IONIC , MATLAB,PHP and ARDUINO. I am very confident with my skills and I'd like to help your bu More
Hi I can write you a python program that does that handling that you described. If you have any questions, do not hesitate to contact me
Hello There! This is Ayesha Siddiqua. Nice to meet with you. I am an M.B.B.S doctor. I have completed my graduation from North Bengal Medical College under Rajshahi University. A versatile and professional Web & Mobil More
I can create python GUI for making the requested changes. Contact me please........................................... Regs Jinu
Hi Dear, Greetings from Alexsandar Going through your project description, I have been interested in it. Could you give me an opportunity to do this job? I would like to discuss more details in chat or interview so we More
i am comfortable for this project. i am experienced in excel for last 5 years and also working in auditor field. i am interested in this project