Em Andamento

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 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 "[url removed, login to view]" transactions in summary

In the attached files, [url removed, login to view] 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

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

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

ID do Projeto: #5148855

Premiar a:

bharanisrihari

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 Freelancer.com. One of the reviews for your reference: "Where Mais

$100 USD em 5 dias
(62 Avaliações)
6.3

25 freelancers estão ofertando em média $127 para este trabalho

seaanddream

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
(55 Comentários)
5.9
nayabsiddiqi

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
(19 Comentários)
5.9
mrbrave

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
(115 Comentários)
5.8
SigmaVisual

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: http://sigma-dns.sigmavirtual.com/PDemo1/Am Mais

$206 USD in 5 dias
(7 Comentários)
5.0
wsh2

Greetings Massachusetts from Easton PA.. {smile} Highly experienced (20+ years) MsExcel business programming professional with Guru / Mentor lvel technical credentials at www.experts-exchange.com and www.vbcity.com. Mais

$157 USD in 3 dias
(13 Comentários)
5.0
maverick44000

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
(19 Comentários)
4.9
ineedWorkJob

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
(20 Comentários)
4.8
dpune

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
(18 Comentários)
4.7
zExcel

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

$120 USD em 1 dia
(21 Comentários)
4.7
finecodervw

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
(23 Comentários)
4.7
swapnilchavan18

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
(7 Comentários)
4.1
Virtualworker50

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
(14 Comentários)
3.8
Edison1983

*******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
(11 Comentários)
3.7
AndroidAll

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
(3 Comentários)
2.7
cyware

Dear sir, I have more then 10 years of experience in VBA so I'm fully qualified to do your job. If the project means adapting your already existing module that outputs the data as in samples then I can do in in t Mais

$60 USD in 3 dias
(3 Comentários)
2.7
vaibhav585

Hi let me handle this project for you, i have read and understood the requirement and i am sure i will be perfect candidate for this work, hope to hear from you "Vaibhav"

$122 USD in 3 dias
(6 Comentários)
2.7
nikhiltechnology

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
(3 Comentários)
1.8
logoDS761

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
(1 Comentário)
1.0
mailsmaity

Ready to work on this.. will deliver project with in time. please assign to me. looking forward to work with you my skype id - mail.smaity

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

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
(2 Comentários)
0.4