Find Jobs
Hire Freelancers

MS Excel macro to query large CSV file

$30-250 USD

In Progress
Posted almost 14 years ago

$30-250 USD

Paid on delivery
We need a simple microsoft excel macro that realizes the following functions. We have two files: 1. ZIP CODE DATABASE - Comma split database with zipcode and corresponding street address1,2,3 2. OUR ORDER INVOICE DATA (xls) - Our store order data with Zip code for delivery address - No street address data (only ZIP code) from customer What we need: We need the so to say Vlookup function that can lookup the ZIP CODE DB using ZIP code as the lookup key, to complete the store order data. the CSV has more that 10K line, thus cannot be opened via xls, so we're looking for a simple macro to realize the "vlookup" function. The macro should have: - Flexibility and which columns it uses as input and output - be automatic so that in one-click, multiple cells in a column can be filled. Looking for xls experts. The budget will be less than $100, and lower bids will have advantage as we're hoping the macro is pretty simple. Thanks everyone!
Project ID: 741821

About the project

29 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
Please check your inbox, best regards
$30 USD in 1 day
4.6 (1 review)
1.6
1.6
29 freelancers are bidding on average $53 USD for this job
User Avatar
HI, I can do it using Excel or Access. Hussien Sharaf
$40 USD in 1 day
5.0 (39 reviews)
6.3
6.3
User Avatar
Looking forward to working with you....
$50 USD in 1 day
4.9 (54 reviews)
6.1
6.1
User Avatar
VBA developer since 1997. Can do. Please refer PM. Thank you. Svet
$80 USD in 3 days
5.0 (41 reviews)
5.9
5.9
User Avatar
I can help you with this. Thank you - Ankita.
$100 USD in 3 days
4.8 (34 reviews)
5.2
5.2
User Avatar
Please see PMB
$66 USD in 0 day
5.0 (43 reviews)
5.1
5.1
User Avatar
Hello please see PM
$30 USD in 2 days
4.9 (18 reviews)
4.7
4.7
User Avatar
Hello Ready to start right now. Please see your PMB for details. Thanks
$30 USD in 2 days
5.0 (13 reviews)
4.3
4.3
User Avatar
Over ten years experience in developing Excel/VBA solutions.
$60 USD in 2 days
4.8 (9 reviews)
4.3
4.3
User Avatar
Exceptional quality & Quick work. Please refer to Profile & Reviews for references and reviews. Thanks FAZ
$75 USD in 0 day
5.0 (13 reviews)
4.1
4.1
User Avatar
Please view my pm. Thanks.
$30 USD in 1 day
5.0 (7 reviews)
4.0
4.0
User Avatar
Hello, *****Your low cost solution provider******
$40 USD in 2 days
4.9 (8 reviews)
3.6
3.6
User Avatar
We have both passion & expertise to do the same.
$30 USD in 5 days
5.0 (5 reviews)
3.4
3.4
User Avatar
Hi If you want to load all 100k lines of data in the xls file to make maintenance easier, consider using conditional vlookup with more than one table. I have sucessfully done one with 10 million records with Excel 2007 recently. I consider Excel 2003 can handle 100k records without any deteriating performance please.
$50 USD in 1 day
5.0 (6 reviews)
3.0
3.0
User Avatar
Hi. Please check PM. Thanks
$90 USD in 2 days
5.0 (4 reviews)
2.9
2.9
User Avatar
See PMB for discussion question, please.
$50 USD in 1 day
2.6 (5 reviews)
3.1
3.1
User Avatar
Hello, I can do this. Please check my PMB. Thank You Paul
$30 USD in 2 days
4.7 (3 reviews)
2.1
2.1
User Avatar
Please see PMB.
$55 USD in 1 day
5.0 (2 reviews)
1.9
1.9
User Avatar
Kono purojekuto ha kantan desu. :D. Let me do it for you. Please refer to my review on Excel project to know my ability.
$50 USD in 3 days
4.6 (1 review)
1.9
1.9
User Avatar
Hello, are you looking for an Excel Expert? See your PM...
$50 USD in 1 day
5.0 (1 review)
1.8
1.8
User Avatar
I have good experience of programming with Office applications of about 7 years now. I can even present a better solution.
$30 USD in 5 days
5.0 (1 review)
1.0
1.0

About the client

Flag of JAPAN
Tokyo, Japan
5.0
5
Member since Jul 13, 2010

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.