Find Jobs
Hire Freelancers

Data Conversion - Parse Excel

$30-100 USD

Completed
Posted over 14 years ago

$30-100 USD

Paid on delivery
We have homeowner information in various Excel spreadsheets and worksheets.? We are moving to an automated system and need to convert the data out of Excel.? I am looking for a macro or some way to convert multiple Excel workbooks.? I've included one workbook for reference. Each spreadsheet is for a single association.? Each worksheet within the spreadsheet represents a homeowner account.? For each account (worksheet tab) certain information needs to be extracted into a format that the new application can import. I created a separate worskeet called ImportAccount and ImportTrans.? ImportAccount contains the listing of accounts to import.? There will be 1 row in this worksheet for every worksheet in the workbook.? The ImportTrans worksheet is a bit more involved.? It needs to create a row for each specified date/charge listed.? So in the Barton tab, columns J-U (except the grey total columns) correspond to a transaction code.? The ImportTrans worksheet has separate sections for each transaction type. So in effect, for each row with a date in column A, column B represents the Description and column J-U represents the appropriate transaction code.? I would like a single listing showing all transactions to be imported.? So a single row in the account worksheet can create multiple rows in the ImportTrans worksheet.
Project ID: 2936936

About the project

13 proposals
Remote project
Active 14 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.
$59.50 USD in 5 days
5.0 (54 reviews)
5.3
5.3
13 freelancers are bidding on average $65 USD for this job
User Avatar
See private message.
$85 USD in 5 days
4.9 (406 reviews)
7.1
7.1
User Avatar
See private message.
$58.65 USD in 5 days
5.0 (106 reviews)
5.9
5.9
User Avatar
See private message.
$85 USD in 5 days
4.7 (58 reviews)
5.7
5.7
User Avatar
See private message.
$102 USD in 5 days
5.0 (64 reviews)
5.5
5.5
User Avatar
See private message.
$75.65 USD in 5 days
4.5 (38 reviews)
5.4
5.4
User Avatar
See private message.
$29.75 USD in 5 days
4.9 (78 reviews)
5.2
5.2
User Avatar
See private message.
$68 USD in 5 days
4.9 (38 reviews)
4.8
4.8
User Avatar
See private message.
$85 USD in 5 days
4.9 (48 reviews)
4.7
4.7
User Avatar
See private message.
$29.75 USD in 5 days
3.0 (33 reviews)
4.8
4.8
User Avatar
See private message.
$76.50 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$51 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$40.80 USD in 5 days
0.0 (0 reviews)
2.9
2.9

About the client

Flag of UNITED STATES
United States
5.0
65
Payment method verified
Member since May 21, 2003

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.