Fermé

We need scripts written to merge data from two sources into one Excel data stream

We sell primarily apparel to one of our clients.

We have an Excel .csv output files that are exported from our ecommerce website we've built for this client. Each file is for a single order and provides that order's data. We also have data that needs to be added from a second Excel CSV worksheet that includes all of our client's operating system's product codes, delivery location codes, purchaser names, General Ledger account codes, and more. We need to merge these two sources of data into a third CSV file that will contain data from multiple orders. We would then send that file to the client at the end of the day that order ships. Attached are two files, one is a sample of the data from the e-commerce website and the second is the template needed to submit that data to the client's operating system. We don't yet have the client's file with all their operating system product numbers, general ledger codes, etc.

Compétences : Saisie de Données, Traitement de Données, Excel, PHP, Visual Basic

en voir plus : need ebooks written, need articles written tonight, need testing written php multiple choice, fme join, fme vlookup, need essay written, need articles written, visual basic scripts excel copy data cells, need resume written, need pre written blog, need program written, need book written, merge files excel duplicates, need scripts, 300 websites need backend written, need report written, need paper written com, need scripts progammers, we need to create a bill format in MS Excel for the patrol pump, We need our association member list put into an excel database

Concernant l'employeur :
( 0 commentaires ) Richmond, United States

Nº du projet : #17702516

53 freelance font une offre moyenne de $381 pour ce travail

jaylancer43

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 ( Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(628 Commentaires)
8.3
mirniyazuddin92

Hi there, I can make scripts to merge data from two sources into one Excel data stream. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(351 Commentaires)
7.7
schoudhary1553

Hello, I have the good knowledge of merge data from two sources into one Excel data stream. I have more than 5 years of experience in Data Entry, Data Processing, Excel, PHP, Visual Basic. I have reviewed your job a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(311 Commentaires)
7.7
extreamcode

HI There, I can assist you write a script which will read from two sources and merge them together. I am very passionate about quality of my work, You will be pleased working with me. Let's have a quick chat to discu Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(70 Commentaires)
7.4
Vlzinch

Hello! I will do the script that will work with 100% accuracy and performance. That's my main direction and I love it to do it. Pls contact me to discuss points of your goals. Regards, Vlad

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(77 Commentaires)
7.5
P0L

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(279 Commentaires)
7.2
gangabass

I can provide you a script that will read your source CSV files (the data from the e-commerce website and the client's file) and generate third file using your template. You have pretty good project description so Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(407 Commentaires)
7.2
AleenaIlyas

Hi there, I have read the details I am experienced with Data Processing, Excel, PHP, Visual Basic. I can help you with this job, Please come to chat so we can discuss this job.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(26 Commentaires)
7.1
aarifakhtar

Hi: I can create a script in Python or VBA which will read the data from both the input files and convert them to the final client template. I have reviewed the two files shared by you, it would be great if we can have Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(170 Commentaires)
7.0
asin1987

Dear Employer, I understand your file Merging job and I will do that for you. Please do try me once. Thanks and Regards, Ash

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(117 Commentaires)
7.0
avinav606lx

Hello there, This looks doable and I'm interested in doing this. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(171 Commentaires)
6.5
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(159 Commentaires)
6.8
chriskerpini

Hello, My name is Chrys. As you can see from my profile, I have 17+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project. I will u Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(85 Commentaires)
6.8
Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(154 Commentaires)
6.4
mamoona016

Hi...! I hope you will be and I want to do your project .i want to start work immediately with my professional expert team and provide 3 month technical support .you pay once when you satisfy 100%.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(71 Commentaires)
6.5
bestit4u

Hi. I am very interested in your project, because I have much experience in such projects. I have good skills with the program language including C/C++, C#, java, php, asp.net, python, VB.NET. So I have expert and s Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(81 Commentaires)
6.8
zekovicm

Hi there,I am Miljan,Excel VBA/Macro 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 wit Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(103 Commentaires)
7.0
devi222

Hi Sir, I can create a script to combine both shesets into one with matching columns I’m a Python Programmer. I have created many Bots to scrape the websites like Amazon(UK, USA, AU, de),Alibaba(suppliers data), Link Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(166 Commentaires)
6.6
panfreelancer

Hi, I am Erfan. I think the goal is to copy some data from the csv file, and copy them to corresponding columns in template xlsx. Is that correct? So some data from csv will be copied correctly to these column Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(80 Commentaires)
5.9
sypsoo

We sell primarily apparel to one of our clients. We have an Excel .csv output files that are exported from our ecommerce website we've built for this client. Each file is for a single order and provides that order's Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(52 Commentaires)
6.3