Completed

Coverting a excel format sales order report from portal to a csv format as required by the supplier

Needs to create a template for order processing in B2B business. I download customer order report in excel or txt file from a B2B portal (online retailing). The orders need to be submitted to the supplier in a specific csv file format. I need a template, where as soon as I populate the downloaded information from B2B portal, it automatically populates everything in csv (tab delimited format), which can be submitted to supplier. I have attached 2 files below. One is the order report example from B2B portal and other file (named -Output), which explains in what format that order report information needs to be converted in csv format. One order line eventually have 3 lines in Output (csv file).

Habilidades: Excel, Microsoft

Ver más: online business portal, b2b portal template, sales report retail excel, excel sales pipeline report, excel sales order, sales report graph excel, excel sales graph report, excel sales report mac, sales report samples excel, excel sales report, sales report macro excel, sales report sample excel

Información del empleador:
( 1 comentario ) Santa Clara, United States

Nº del proyecto: #8986110

Adjudicado a:

gokulanand

Hello I can get you this task done using Excel VBA Programming. Everything will be automated via a button click. Please share me the files, if you are interested. Thanks

$30 USD en 0 días
(73 comentarios)
5.5

8 freelancers están ofertando el promedio de $27 para este trabajo

prameswara

A proposal has not yet been provided

$15 USD en 1 día
(162 comentarios)
6.0
Khurramz

Possible Solution: Paste in the order in Sheet1 and get csv ready in Sheet2 (I'll link all the data from Sheet1 to Sheet2) Then you can save Sheet2 as csv and submit.

$24 USD en 1 día
(78 comentarios)
4.9
macroPOL

Hello, I am Excel and VBA expert. I can complete this project. I need a sample output file that you need. Please note that I have 100% completion rate and 5-star feedback on projects.

$30 USD en 3 días
(19 comentarios)
4.5
kolosibalint

Hi, I have 3 years of experience in VBA programming. I currently work as a business data analyst at Ford Motor Company creating automated reports, dashboards, forms. I can start working on your project immediate Más

$30 USD en 3 días
(23 comentarios)
3.9
jennalynferanil

Hello, I think you forgot to attached the files? I cannot see it. Hoping to hear from you. Have a great day!

$35 USD en 1 día
(7 comentarios)
3.1
DMcCarthy89

Hi, I am a scientist by profession with extensive experience in creating Excel platforms for importing, reorganising and subsequently exporting data in custom formats from specific import files. I will be able to quic Más

$25 USD en 1 día
(9 comentarios)
3.0
subarnapal

Possess excellent skill in converting data format, automating steps etc. Very much committed to quality of the job and timeline.

$25 USD en 1 día
(0 comentarios)
0.0