Update Custom VBA script to incorporate new CSV input format and features
$30-250 USD
Paid on delivery
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 Squareup.com.)
Changes:
* 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.
Project ID: #5148855
About the project
21 freelancers are bidding on average $129 for this job
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 More
Hi, I can help you with and can work on it now if you're ready to start. ------------------------------------------------------------------------------------------------------------
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
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..
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 More
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 More
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 More
*******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 More
Hello I can update Custom VBA script to new CSV input format and features I can start the work now Regards Nikhil
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 More
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 More
VBA Programmer and Data Processing Expert here. Got 6 years Experience in Web Programming, Software Programming and Database Design. Regards, mleo
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.
I have over 5 years of experience in MS-Excel VBA. I can finish the work in a day with high quality.
Hello, In my current job at Honeywell I work on similar projects where the inputs are in CSV and XML formats and the data in them needs to be read then processed and the output stored and saved in an Excel file. More