Closed

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
Employer working
Awarded to:
Skills Required
Project Budget
$30-$100 USD
Total Bids
4
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 [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.


## Deliverables

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online