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).
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 freelancers están ofertando el promedio de $27 para este trabajo
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.