Devam Ediyor

MS Excel macro to query large CSV file

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!

Beceriler: Microsoft, Visual Basic

Daha fazlasını görün: query large csv, macro large database excel, excel query csv file, query large csv files, query large csv file, we excel, need experts excel, ms lookup, experts excel microsoft, macro query csv files, macro excel query csv, macro large csv, large macro file, large csv macro, large csv file macro, uses excel, microsoft macro, less excel, excel uses, excel split columns, excel less, simple query, simple macro, simple csv, order split

İşveren Hakkında:
( 5 değerlendirme ) Tokyo, Japan

Proje NO: #741821

Seçilen:

maap0404

Please check your inbox, best regards

1 gün içinde 30$ USD
(1 Değerlendirme)
1.6

29 freelancer bu iş için ortalamada 53$ teklif veriyor

HussienSharaf

HI, I can do it using Excel or Access. Hussien Sharaf

1 gün içinde 40$ USD
(39 Değerlendirme)
6.3
xamdam91

Looking forward to working with you....

1 gün içinde 50$ USD
(54 Değerlendirme)
6.1
svet63

VBA developer since 1997. Can do. Please refer PM. Thank you. Svet

in 3 gün içinde80$ USD
(41 Değerlendirme)
5.9
MAnkita

I can help you with this. Thank you - Ankita.

in 3 gün içinde100$ USD
(34 Değerlendirme)
5.2
koolsidz

Please see PMB

in 0 gün içinde66$ USD
(43 Değerlendirme)
5.1
djucuti

Hello please see PM

in 2 gün içinde30$ USD
(18 Değerlendirme)
4.7
KellogITSolution

Hello Ready to start right now. Please see your PMB for details. Thanks

in 2 gün içinde30$ USD
(13 Değerlendirme)
4.3
vbexcel

Over ten years experience in developing Excel/VBA solutions.

in 2 gün içinde60$ USD
(9 Değerlendirme)
4.3
oFAZo

Exceptional quality & Quick work. Please refer to Profile & Reviews for references and reviews. Thanks FAZ

in 0 gün içinde75$ USD
(13 Değerlendirme)
4.1
panfreelancer

Please view my pm. Thanks.

1 gün içinde 30$ USD
(7 Değerlendirme)
4.0
DeliveringIT

Hello, *****Your low cost solution provider******

in 2 gün içinde40$ USD
(8 Değerlendirme)
3.6
nsurani

We have both passion & expertise to do the same.

in 5 gün içinde30$ USD
(5 Değerlendirme)
3.4
cheungkc

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 fazlası

1 gün içinde 50$ USD
(6 Değerlendirme)
3.0
ruimaxwell

Hi. Please check PM. Thanks

in 2 gün içinde90$ USD
(4 Değerlendirme)
2.9
softwarehandyman

See PMB for discussion question, please.

1 gün içinde 50$ USD
(5 Değerlendirme)
3.1
ympaul

Hello, I can do this. Please check my PMB. Thank You Paul

in 2 gün içinde30$ USD
(3 Değerlendirme)
2.1
pradeep1210

Please see PMB.

1 gün içinde 55$ USD
(2 Değerlendirme)
1.9
beepig

Kono purojekuto ha kantan desu. :D. Let me do it for you. Please refer to my review on Excel project to know my ability.

in 3 gün içinde50$ USD
(1 Değerlendirme)
1.9
iQraTechnologies

Hello, are you looking for an Excel Expert? See your PM...

1 gün içinde 50$ USD
(1 Değerlendirme)
1.8
togenius

I have good experience of programming with Office applications of about 7 years now. I can even present a better solution.

in 5 gün içinde30$ USD
(1 Değerlendirme)
1.0