Coverting a excel format sales order report from portal to a csv format as required by the supplier
$10-30 USD
货到付款
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).
项目ID: #8986110
关于项目
授予:
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
有8名威客正在参与此工作的竞标,均价$27/小时
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.
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.
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 更多
Hello, I think you forgot to attached the files? I cannot see it. Hoping to hear from you. Have a great day!
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 更多
Possess excellent skill in converting data format, automating steps etc. Very much committed to quality of the job and timeline.