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

已完成 已发布的 Nov 27, 2015 货到付款
已完成 货到付款

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 微软

项目ID: #8986110

关于项目

8个方案 远程项目 活跃的Nov 27, 2015

授予:

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 在0天内
(73条评论)
5.5

有8名威客正在参与此工作的竞标,均价$27/小时

prameswara

A proposal has not yet been provided

$15USD 在1天里
(162条评论)
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.

$24USD 在1天里
(78条评论)
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 在3天内
(19条评论)
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 更多

$30 USD 在3天内
(23条评论)
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!

$35USD 在1天里
(7条评论)
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 更多

$25USD 在1天里
(9条评论)
3.0
subarnapal

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

$25USD 在1天里
(0条评论)
0.0