Merge CSV with Zip Code to Excel file

£10-20 GBP

Ukończony

Opublikowano

ponad 9 lat temu

£10-20 GBP

Płatne przy odbiorze

Attached Excel file has a "Template" worksheet which is duplicated by Macro and filled with data from the attached CSV file. The "New Invoice as Needed" worksheet shows how the data SHOULD look after merging. The "New Invoice as merges" worksheet shows what happens in practise. For some reason the Macro is not identifying the circumflex (^) dividers and dumping all the Data into the Customer Contact Details box. I will send a Private Message to enable bidders to to send me a document that works properly. PLEASE do not waste time with "other" attachments, or assurances that you CAN do this if you cannot, Need this sorted within 24 hours please.

Visual Basic

Identyfikator projektu: 7035623

Informację o projekcie

11 ofert

Zdalny projekt

Aktywny 9 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Adres e-mail

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe

Otrzymuj wynagrodzenie za swoją pracę

Przedstaw swoją propozycję

Rejestracja i składanie ofert jest bezpłatne

Przyznano:

@macroPOL

updating: [login to view URL] Hello, I have done it. I may send you YouTube video (a document that works properly) in 2 hours from now. (I can not send it from computer where I am now). Best Regards Jan Krzyzak

£18 GBP w 0 dzień

5,0

(2 opinii)

2,2

11 freelancerzy składają oferty o średniej wysokości £23 GBP dla tej pracy

@zExcel

A proposal has not yet been provided

£28 GBP w 0 dzień

4,9

(55 opinii)

6,1

@envisionops

A proposal has not yet been provided

£20 GBP w 0 dzień

5,0

(16 opinii)

4,2

@nagybatonyi

I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I have analysed your CSV file and found the cause of your problem. I can tell you what you should avoid in generating the CSV file in order to avoid this problem in the future or I can add some code to your existing macro to handle the changed layout of the CSV file (I suppose it worked well earlier), you can choose the option that suits your needs better. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards

£18 GBP w 1 dzień

4,9

(14 opinii)

3,9

@dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 220 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.

£20 GBP w 3 dni

4,9

(10 opinii)

3,9

@adityasl

Hello, I have made some change. Please send me message so that I can send the file created and let me know any change needed. Looking forward for the reply. Regards, Aditya

£18 GBP w 1 dzień

5,0

(12 opinii)

2,9

@milanmartinjuk

Hi, Your project sounds very interesting and simple enough and I believe that I'll be able to perform the task perfectly. As for my experience, you can see for yourself that I've worked here mainly as a content and article writer; but, I've also done some VA work, which included blog posting, forum posting, article spinning, audio transcribing, etc. You're welcome to check my reviews and should you have any questions, I'll be happy to answer. Kindest regards. Milan

£19 GBP w 1 dzień

5,0

(1 opinia)

1,4

@mmoreyra

Dear Employer, The problem is not in your macro but in your CSV file. I managed my self to produce an invoice as expected after fixing your CSV file. I can send you the generated invoice before awarding the project so you can check if the output is ok. Thanks in advance! Mariano

£18 GBP w 0 dzień