Update Custom VBA script to incorporate new CSV input format and features

We have an existing VBA script for Microsoft Excel that processes a CSV input and produces an Excel file as output. However, the format of the CSV has changed slightly, as have our needs, and we'd like the script to account for those changes. (The CSV file is produced by


* For input files not containing the "Coupon" variant, we'd like the output file to exclude the "Coupon" columns

* The input format of check transactions has changed slightly, and as such, they're currently being mis-categorized by the script. (They're being included in the "other card" column, rather than the "cash and chq" column)

Wish-list Changes:

* Accurately account for refunds based on payment ID

* Ignore "0.00" transactions in summary

In the attached files, [login to view URL] is the current script. Other files are sample input and output (both current output and ideal output) for a variety of scenarios.

Habilidades: Excel, Visual Basic para Apps

Veja mais: custom list in excel, check in to cash, microsoft vba, microsoft excel VBA, excel 2013 vba, incorporate, excel vba script, csv script vba, coupon sample, vba update excel, microsoft excel account, 2013 visual basic applications excel, excel 2013 microsoft visual basic, sample visual basic excel, csv update, xls visual basic, csv column format, 2013 excel visual basic, excel column update, transactions script, microsoft excel 2013 visual basic, vba file list excel, microsoft visual basic applications, microsoft excel script, check excel files

Acerca do Empregador:
( 8 comentários ) Cambridge, United States

ID do Projeto: #5148855

Concedido a:


Hi, I'm an Excel expert / VBA programmer. I can get your requirements done perfectly! Please refer the excellent reviews for my completed projects in One of the reviews for your reference: "Where Mais

$100 USD em 5 dias
(69 Comentários)

23 freelancers estão ofertando em média $128 para esse trabalho


Hello; your 5-star excel and vba coding expert is ready to help you.. kindly check my profile and feedbacks first to have some idea about the quality of my work... I had many similar vba tasks, all achieved with 5/5 ra Mais

$100 USD in 3 dias
(250 Comentários)

Hi, I can help you with and can work on it now if you're ready to start. ------------------------------------------------------------------------------------------------------------

$120 USD em 1 dia
(252 Comentários)

Hi HarvardBooks. I am quite eager to start up on this project. I have done various Excel projects with a lot of degree of difficulty and I am ready to start with yours too. Hoping to read back from you Regards

$190 USD in 3 dias
(71 Comentários)

Lets start....I am VBA expert with great experience...I have completed over 100 VBA projects on this site...I am available to start off now and can provide Macro for test with 12 hours..

$92 USD in 2 dias
(205 Comentários)

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

$138 USD in 3 dias
(115 Comentários)

being expert, can provide you the stable consolidation, fix the current macro to transform correctly with the mentioned wishlist changes. Would be able to deliver in 3 days and can provide you the test version for you Mais

$126 USD in 3 dias
(27 Comentários)

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert desktop software/macro/bot/ Mais

$150 USD in 3 dias
(22 Comentários)

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: [login to view URL] Mais

$206 USD in 5 dias
(8 Comentários)

I am interested to do this project. Please discuss with me before finalizing your decision. Thanks. Looking forward for long term and better relationship with you. I am serious bidder on freelancer and looking forward Mais

$200 USD in 3 dias
(15 Comentários)

Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word etc.. I have more than 10 years of experience to my credit. I have also worked on advanced VB features li Mais

$250 USD in 10 dias
(22 Comentários)

*******I've finished half of your work. Once you award this project, i'll finish rest of the task & will share with you the output instantly in few mins***** Good Day!... I'm a VBA Programmer, having 6+ years of Mais

$70 USD in 0 dias
(21 Comentários)

Hello I can update Custom VBA script to new CSV input format and features I can start the work now Regards Nikhil

$144 USD in 3 dias
(21 Comentários)

Respected Sir, It would be pleasure for me to render my services to you for making amendment/updation of vba code in excel. I am advance level user of excel and assure you the quality and timely work. If you Mais

$130 USD in 2 dias
(12 Comentários)

Dear Sir, I'm interesting in your job. I have much experience in the MS Excel and VBA. I can do this job. Regards. PS. In order to show my ability, I can send my sample files to you.

$130 USD in 3 dias
(14 Comentários)

Hi I'm 12 year experienced VBA developer... My expertise is on debugging and error fixing.. Please have a look at my profile to see what employers are saying about me... I will deliver high quality results on record ti Mais

$70 USD in 4 dias
(4 Comentários)

hello, i had highly experience 10 years in vb6 + vba macros in all MS. office soft (2002 - 2013), OpenOffice Calc 3.5 and 4.0 i did later this month successfully "Created at run-time by macros code 500 Check-box Mais

$90 USD in 5 dias
(2 Comentários)

Ready to work on this.. will deliver project with in time. please assign to me. looking forward to work with you my skype id - [login to view URL]

$147 USD in 3 dias
(1 Comentário)

Sir, That macro improvement is case which we perform so often. That is just life. I am doing macro projects as my hobby after work. I am cheaper than other, because my rate excjange is better. 4 days, and You will be s Mais

$100 USD in 4 dias
(1 Comentário)

I have lots of experience developing in VBA with Excel and these changes don't look too hard. The wish-list changes look very doable as well and wouldn't be a problem to include.

$100 USD in 3 dias
(0 Comentários)

I have over 5 years of experience in MS-Excel VBA. I can finish the work in a day with high quality.

$111 USD em 1 dia
(0 Comentários)