Excel data cleaning and validation

Befejezett Kiadva: 5 évvel ezelőtt Kiszállításkor fizetve
Befejezett

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

Projektazonosító: #17728821

A projektről

54 ajánlat Távolról teljesíthető projekt Utoljára aktív: 5 évvel ezelőtt

Odaítélve:

GopalJp

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 Továbbiak

$17 AUD / óra
(33 értékelés)
6.7
AkilaArun

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 Továbbiak

$15 AUD / óra
(57 értékelés)
5.7

54 szabadúszó tett átlagosan 20$/órás árajánlatot erre a munkára

schoudhary1553

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 Továbbiak

$25 AUD / óra
(509 vélemény)
8.4
paris2785

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 Továbbiak

$15 AUD / óra
(499 vélemény)
8.4
bouslimi1979

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 / óra
(334 vélemény)
7.9
sloker18

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 Továbbiak

$20 AUD / óra
(162 vélemény)
7.5
zekovicm

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 Továbbiak

$22 AUD / óra
(159 vélemény)
7.8
TonmoyRoy111

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 / óra
(497 vélemény)
7.4
daniyal3214

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 / óra
(177 vélemény)
7.1
amirn2011

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 Továbbiak

$15 AUD / óra
(88 vélemény)
6.5
sknadeem123

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 / óra
(72 vélemény)
6.3
Venkylancing

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 Továbbiak

$16 AUD / óra
(138 vélemény)
6.6
SPARKtechBD

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 Továbbiak

$15 AUD / óra
(15 vélemény)
5.6
sajibdigital

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 / óra
(81 vélemény)
5.8
renesontiongson

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 / óra
(73 vélemény)
5.7
jasalaz100

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 Továbbiak

$17 AUD / óra
(33 vélemény)
5.2
ZeeshanShah22

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 / óra
(20 vélemény)
4.8
SunniaImran

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 Továbbiak

$16 AUD / óra
(12 vélemény)
3.8
nishantha041

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 Továbbiak

$15 AUD / óra
(5 vélemény)
2.9
mahpour1987

Hi sir, I am an experienced C#.NET programmer with over 13 years of experience. I can complete your job within the shortest time with programming combined with my experiences. I have tried to have a brilliant review Továbbiak

$15 AUD / óra
(2 vélemény)
2.1
roshanasim

I have worked on Web Data Mining- Web Harvesting- Email address and contact detail extraction from web- Web data collection- Plain data entry- JPG/PDF to DOC file- Entry in Excel/ACT- Link Exchange on the web. Data Tra Továbbiak

$20 AUD / óra
(0 vélemény)
0.0
dote2018

Hi dear I’m a senior developer and have developed hundreds of VB projects, I’m interested in your project, and my cheap fee is because we are new here but not noob. The quality of the final job could be guaranteed how Továbbiak

$15 AUD / óra
(0 vélemény)
0.0