Find Jobs
Hire Freelancers

CSV to Excel Parser

$30-100 USD

Completed
Posted almost 15 years ago

$30-100 USD

Paid on delivery
Parse thru a CSV file, subtotal, and remove records based on the subtotal amount. Output to a new excel file. Implement using an Excel VBA macro from the output file. Example of the CSV file: Type,Date,Num,Name,Memo,Account,Clr,Split,Amount,Balance Deposit,6/12/2008,0,01-002741 Schumann,Deposit,impounds,,,473.4,3322.76 Deposit,6/12/2008,737,05-002005 Diaz,Deposit,appraisal,,,375,475 Deposit,6/12/2008,1043,33-000412 Quintero,Deposit,appraisal,,,400,875 Deposit,6/12/2008,103,33-000440 Bradley,Deposit,appraisal,,,400,1275 Check,6/23/2008,wire,01-002741 Schumann,,impounds,,,-473.4,71003.07 … ## Deliverables Attached is a ZIP file containing 2 files: 1) [login to view URL] - a sample of data 2) [login to view URL] - a sample of the final output based on the sample [login to view URL] Here's the intended workflow: 1) We export data from another software data into the [login to view URL] file. 2) We open the [login to view URL] file (in the same folder as [login to view URL]) 3) We click a button in the [login to view URL] file 4) The macro does it's stuff resulting in the output. Here's what the macro needs to do 1) Remove the last row in the [login to view URL] file. (The row that has the word total in column A). 2) Sort the data in the [login to view URL] file by the “Name?? column, Subtotal the “Amount?? column on change in the “Name?? column. 2) Remove all records for a given “Name?? which subtotal is zero. (including the subtotals) 3) Erase any remaining data in the [login to view URL] file 4) Output the remaining records and subtotals from Steps 1 and 2 into the [login to view URL] file. 5) Remove the “Balance?? column from the [login to view URL] file 5) Bold Every Row containing a subtotal. 6) Set the format of column J to currency. 5) Output in the same excel file at the bottom a subtotal by the “Amount?? column on the change in the “Account?? column.
Project ID: 3776644

About the project

32 proposals
Remote project
Active 15 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$51 USD in 2 days
5.0 (55 reviews)
5.3
5.3
32 freelancers are bidding on average $44 USD for this job
User Avatar
See private message.
$41.65 USD in 2 days
5.0 (517 reviews)
7.6
7.6
User Avatar
See private message.
$76.50 USD in 2 days
5.0 (734 reviews)
7.5
7.5
User Avatar
See private message.
$85 USD in 2 days
4.9 (407 reviews)
7.1
7.1
User Avatar
See private message.
$59.50 USD in 2 days
5.0 (173 reviews)
6.3
6.3
User Avatar
See private message.
$68 USD in 2 days
5.0 (117 reviews)
6.0
6.0
User Avatar
See private message.
$63.75 USD in 2 days
4.7 (256 reviews)
6.5
6.5
User Avatar
See private message.
$34 USD in 2 days
4.9 (83 reviews)
5.2
5.2
User Avatar
See private message.
$85 USD in 2 days
4.9 (52 reviews)
4.9
4.9
User Avatar
See private message.
$15.30 USD in 2 days
5.0 (92 reviews)
4.7
4.7
User Avatar
See private message.
$21.25 USD in 2 days
4.9 (17 reviews)
4.2
4.2
User Avatar
See private message.
$25.50 USD in 2 days
5.0 (18 reviews)
3.7
3.7
User Avatar
See private message.
$42.50 USD in 2 days
5.0 (2 reviews)
3.5
3.5
User Avatar
See private message.
$34 USD in 2 days
5.0 (18 reviews)
3.6
3.6
User Avatar
See private message.
$17 USD in 2 days
4.5 (6 reviews)
3.6
3.6
User Avatar
See private message.
$17.85 USD in 2 days
5.0 (3 reviews)
2.5
2.5
User Avatar
See private message.
$42.50 USD in 2 days
4.9 (6 reviews)
2.7
2.7
User Avatar
See private message.
$42.50 USD in 2 days
5.0 (3 reviews)
2.3
2.3
User Avatar
See private message.
$34 USD in 2 days
5.0 (2 reviews)
2.0
2.0
User Avatar
See private message.
$63.75 USD in 2 days
5.0 (4 reviews)
1.6
1.6
User Avatar
See private message.
$21.25 USD in 2 days
3.2 (2 reviews)
1.6
1.6

About the client

Flag of UNITED STATES
Los Alamitos, United States
5.0
4
Member since Oct 23, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.