Excel VBA Macro - Spreadsheet conversion
- or -
Post a project like this1642
£50(approx. $63)
- Posted:
- Proposals: 7
- Remote
- #2578069
- Awarded
Excel Dashboard, Reporting Expert | VBA, Macros |Business Intelligence and Data Analytics | Power BI | Financial Analysis | Google Spreadsheet Design and Scripting | Python Expert | MT4 | MT4 Manager
Pune
TOP PRO - Excel, Word, PowerPoint, VBA, Google Sheet, Outlook, Access, Database, Scripting
Bay Minette
Trusted CRM Consultant and Data Automation Expert. Automating your business, designing your future!
Mumbai
14358896836812644632642406274413832124703239818
Description
Experience Level: Entry
I will export the order information as a Excel file from my Brightpearl dispatch software. It will then need to be converted to suit the requirements of the order fulfillment company in Spain called B2C Europe.
I have attached a file called ‘BP Order Info’ this is how the order information will look once I download it from Brightpearl. I have put in line 2 which column this info should go in the ‘Sales_Order_Example_’ file. PPH won't let me send an XML file for some reason so I have attached the Excel version. Can email it over to you.
The other file is called ‘Sales_Order_Example_’ this is an example of how B2C want the file to look before it is uploaded to their system. The PDF ‘Sales_Order_Specification’ is further specifications of the B2C requirement. Luckily a lot of the information is not mandatory.
Another developer started work on this but had to go away for a few weeks, I can send you the work he started if it helps and also his comments on his progress.
I have attached a file called ‘BP Order Info’ this is how the order information will look once I download it from Brightpearl. I have put in line 2 which column this info should go in the ‘Sales_Order_Example_’ file. PPH won't let me send an XML file for some reason so I have attached the Excel version. Can email it over to you.
The other file is called ‘Sales_Order_Example_’ this is an example of how B2C want the file to look before it is uploaded to their system. The PDF ‘Sales_Order_Specification’ is further specifications of the B2C requirement. Luckily a lot of the information is not mandatory.
Another developer started work on this but had to go away for a few weeks, I can send you the work he started if it helps and also his comments on his progress.
Projects Completed
140
Freelancers worked with
112
Projects awarded
42%
Last project
29 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Will you please be able to email me the XML file to vijaymishra1105@gmail.com
857141
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies