Update Custom VBA Script for Microsoft Excel

IN PROGRESS
Bids
4
Avg Bid (USD)
$44
Project Budget (USD)
$30 - $100

Project Description:
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 Squareup.com, 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. Squareup.com 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.


## Deliverables

New sample CSV files attached as ZIP

Skills required:
Script Install, Shell Script
Additional Files: vw_2012___07___05___vWorker_RAC_NameCryptedToProtectYourPrivacy_X201275101225892283166872846360025282156.zip
Hire harvardbooks
Project posted by:
harvardbooks United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire quickprogexpert
$ 30.6
in 14 days
Hire chriskerpini
$ 40.8
in 14 days
Hire Baxter2008
$ 25.5
in 14 days
$ 80.75
in 14 days