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.
The actual zipcode db (column 2 zipcode, 3-5 street addresses) and output xls uploaded. For your reference.
29 freelancers are bidding on average $53 for this job
VBA developer since 1997. Can do. Please refer PM. Thank you. Svet
Hello Ready to start right now. Please see your PMB for details. Thanks
Over ten years experience in developing Excel/VBA solutions.
Exceptional quality & Quick work. Please refer to Profile & Reviews for references and reviews. Thanks FAZ
Hello, *****Your low cost solution provider******
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 Exce Daha Fazla
Hello, I can do this. Please check my PMB. Thank You Paul
Kono purojekuto ha kantan desu. :D. Let me do it for you. Please refer to my review on Excel project to know my ability.
I have good experience of programming with Office applications of about 7 years now. I can even present a better solution.