Excel data cleaning and validation

We import a spreadsheet in a database and we need to make sure the data is correct.

1. We need to check if the product exists in our tbl_invoiceIt.xlx. If it does not we either need to flag/update our listing or correct it (the most common)

2. We need to check if a purchase order and/or work order have been received in JCA_received. If not, we need to flag it so that we can’t import it

3. We need to match the purchase order and the work order. Sometimes the logistic company sends us older purchase order or work order. If a PO exist in DB, then it could have already been assigned to another job. But sometimes the PO is for multiple jobs and it needs to allow import after checking

4. We also need to check if the work order is for one or more jobs. [login to view URL] list the quantity

More details in the zip file

Квалификация: Excel, Excel VBA, Visual Basic

Показать больше excel data validation custom list, custom data validation in excel, data validation excel list, data validation excel 2016, data validation excel drop down list, how to clean data in excel 2010, excel data validation based on another cell, data cleaning in excel pdf, excel data validation empty cell 2007, data cleaning excel, excel data cleaning, excel project data cleaning, export excel data fnm file, data cleaning excel macro, excel data entry file, need programmer importtext file excel data base, export excel data file tradestation, excel data validation extraction, data cleaning excel methods, excel data capture validation

О работодателе:
( 23 отзыв(-а, -ов) ) CAMPERDOWN, Australia

ID проекта: #17728821



Hi Sir, I am able to do this project. I have good knowledge on excel and the following accounting software as well:- -Xero -Quickbooks -Quickbooks Online -Zoho Books -MYOB -SAP Fico -Tally ERP -In-house d Больше

$17 AUD / час
(0 отзывов(-а))

Hi, I am interested in discussing this task. Saw the sample files attached with the task. Would like to clarify each step so that I am on the same page. Will this be an ongoing task or one time clean up ? Looking Больше

$15 AUD / час
(35 отзывов(-а))

57 фрилансеров(-а) в среднем готовы выполнить эту работу за $20/час


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Больше

$25 AUD / час
(625 отзывов(-а))

Dear, I need to have a short discussion about the requirements. Specially for how you want to "flag" records. Also some explanation about the logic. Best regards, Issam

$15 AUD / час
(244 отзывов(-а))

Hello! My name's Sandeep and I was glad to see that you're looking for help for project Excel data cleaning and validation. I've delivered more than 400 projects in the last 3 years and this makes me very confident Больше

$25 AUD / час
(274 отзывов(-а))

Hello! My name is Paris and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel because this is my favorite field and MS Excel projects are among the tasks I work with Больше

$15 AUD / час
(156 отзывов(-а))

Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the ag Больше

$22 AUD / час
(76 отзывов(-а))

Dear Client, I would like to discuss with you about the project. I have good knowledge in excel and I can definitely help you in this project. So please contact me. Roy

$20 AUD / час
(264 отзывов(-а))

dear sir, i have gone through your job description and i understand it completely, i can do this job for you, as i am good at excel, validation, checking, and POs, SOs, will check thoroughly and act according to th Больше

$16 AUD / час
(138 отзывов(-а))

Expert on maintain Excel files for data processing and building Excel VBA Macro to automate Excel data sheet. Have more than 15 years of experience on Visual Basic. 15+ years of experience on Computer Language and D Больше

$15 AUD / час
(11 отзывов(-а))

excellent i am perfect this job and am sure i will check and perform task as you needed and am also ready to test work if needed. Thank you

$15 AUD / час
(46 отзывов(-а))

Hi there, I am expert in excel formula and macro. I think it will be easy for me. You may check my profile for trust me. Thanks

$16 AUD / час
(61 отзывов(-а))
$15 AUD / час
(66 отзывов(-а))

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.

$15 AUD / час
(68 отзывов(-а))

Hi, I am ready for your Excel data cleaning and validation project. Already I have completed over 160 project in freelancer, especially in data entry, web research & also few calling tasks. As per your project requ Больше

$15 AUD / час
(34 отзывов(-а))

Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after com Больше

$17 AUD / час
(26 отзывов(-а))

I am a professional Excel expert holding years of experience in utilizing advance level tools and functions of Excel to prepare highly dynamic and automated excel based dashboards and templates.

$15 AUD / час
(34 отзывов(-а))

I am proficient with excel macro/VBA development, I have gone through your attached workbook and document, I can write the macro to perform the validation as requested, if you are interested feel free to message me, I Больше

$20 AUD / час
(39 отзывов(-а))

I am a statistical analyst, with strong background of Pure Statistics including a strong grip on statistical software including SPSS, Excel, Minitab, STATA, SAS, Mathematica, Statistica and Eviews.

$25 AUD / час
(15 отзывов(-а))

Here is the right person you are looking for. I am willing and ready to take up your project right away. I am sure that I can do it within your required time and format. The client satisfaction is always my prime con Больше

$16 AUD / час
(12 отзывов(-а))

Dear Sir, I went through your project description and also attached files. I can work on this project as you want. I have many years of experience with excel vba and I can assure to deliver error free output. Further Больше

$15 AUD / час
(5 отзывов(-а))

Hello, My name is Angelica and I think I’d be a great fit for your project. I worked as an internal auditor for more than three years, examining records, documentation, operating practices, and creating reports to d Больше

$15 AUD / час
(1 отзыв)