Update Custom VBA Script for Microsoft Excel
This project was awarded to quickprogexpert for $30.6 USD.Get free quotes for a project like this
Project Budget$30 - $100 USD
We have an existing VBA script for Microsoft Excel that processes a CSV input and produces an Excel file as output. However, the format of the CSV has changed slightly, and we'd like the script to account for those changes. (The CSV file is produced by [url removed, login to view], which recently changed a few details.)
1. Currently the script tallies "Card - Swiped" transactions; we'd like for it to also account for "Card - Keyed" transactions (which are just credit card transactions that had to be manually keyed in at the point-of-sale -- there's no difference in any other way).
2. [url removed, login to view] added a new column after "subtotal" (they added "discount"), which pushes everything over a column.
3. Finally, cash transactions are no longer identified by the "Payment Method" column. Instead, they're only identified in the "Payment Type" field.
The script and new sample CSV files are attached.
New sample CSV files attached as ZIP
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online