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

Concluído Postado Nov 27, 2015 Pago na entrega
Concluído Pago na entrega

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).

Excel Microsoft

ID do Projeto: #8986110

Sobre o projeto

8 propostas Projeto remoto Ativo em Nov 27, 2015

Concedido 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 em 0 dias
(73 Comentários)
5.5

8 freelancers estão ofertando em média $27 nesse trabalho

prameswara

A proposal has not yet been provided

$15 USD em 1 dia
(162 Comentários)
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 em 1 dia
(78 Comentários)
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 in 3 dias
(19 Comentários)
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 Mais

$30 USD in 3 dias
(23 Comentários)
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 em 1 dia
(7 Comentários)
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 Mais

$25 USD em 1 dia
(9 Comentários)
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 em 1 dia
(0 Comentários)
0.0