Visual Basic Macro Needed
- or -
Post a project like this4799
£100(approx. $125)
- Posted:
- Proposals: 15
- Remote
- #55453
- Awarded
Mobile App Development, Python, Power BI, Flutter, Angular, Android, IOS, Developer, Django, Ionic Framework, React JS, PHP, Web, Startup
Dartford
1203581787158782769118881410623912511812653412946213564613901215693
Description
Experience Level: Intermediate
I\'m looking for someone to develop a Visual Basic Macro to convert an existing CSV file exported from Quickbooks into a txt file that our shipping software
will accept. The Macro will need to...
1. remove records that don\'t meet a certain criteria.
2. pick up the customers ship to address if one exsists otherwise pick up the billing address.
3. move that data, along with some other data contained in the CSV file exported from Quickbooks, to a separate worksheet that can then be saved in a CSV file to be imported by the shipping software.
4. the user should be able to simply click on the macro to initiate and complete the process.
Samples of both CSV files can be found at...
www.pondsupplies.ca/temp/Transaction_Exporter_Sales_Orders.csv
www.pondsupplies.ca/temp/OUTPUT_sample_layout 2.txt
Dan
will accept. The Macro will need to...
1. remove records that don\'t meet a certain criteria.
2. pick up the customers ship to address if one exsists otherwise pick up the billing address.
3. move that data, along with some other data contained in the CSV file exported from Quickbooks, to a separate worksheet that can then be saved in a CSV file to be imported by the shipping software.
4. the user should be able to simply click on the macro to initiate and complete the process.
Samples of both CSV files can be found at...
www.pondsupplies.ca/temp/Transaction_Exporter_Sales_Orders.csv
www.pondsupplies.ca/temp/OUTPUT_sample_layout 2.txt
Dan
Dan C.
100% (7)Projects Completed
11
Freelancers worked with
10
Projects awarded
25%
Last project
5 Aug 2015
Canada
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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