Visual basic expert Needed for multiple projects. - 31/10/2016 09:02 EDT
$30-250 AUD
착불
I have a set of approx 90 standardized excel files (in .csv format), which all need to be manipulated the same way. I need a script that I can run as I get more of the same files over time. This is what it needs to do (some details removed, will be delivered upon starting the assignment):
Step 1: Delete columns a&b&d&h&j&p&q
Step 2: Insert 4 columns before column A
Step 3: add the following Column Headers in Row 1:
Field A1 =
Field B1 =
Field C1 =
Field D1 =
Field E1 =
Step 4: Insert 7 columns between columns E and F
Step 5: add the following Column Headers in Row 1:
Field F1 =
Field G1 =
Field H1 =
Field I1 =
Field J1 =
Field K1 =
Field L1 =
Field M1 =
Step 6: Remove the "X" throughout column M
Step 7: Move the first cipher from Column M to Column L.
Step 8: add the following Column Headers in Row 1:
Field N1 =
Field O1 =
Field P1 =
Field Q1 =
Field R1 =
Field S1 =
Field T1 =
Field U1 =
Field V1 =
Field W1 =
Step 9:
The text in Column N needs to be abbreviated according to the following rules:
Step 10: Column I must match column E, but all space must be exchange for -'s.
Step 11: Save as .csv and return
프로젝트 ID: #11941926
프로젝트 소개
이 일자리에 대한 프리랜서 43 명의 평균 입찰가: $104
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/word/outlook VBA automation professional having 7+ years of experience and can do it with the required quali 기타
I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfe 기타
Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with vari 기타
I have expertise in excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients. Thank you..
I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, f 기타
hi sir, i will create the visual basic exe for these csv operations. thanks....................................................
Hi, I have ~4+ years of experience of creating and operating low to very high complexity of Excel/VBA/SQL,SAS, Powerpoint, QlikView based tools/processes, reports. I can assure you of high quality and on-time de 기타
Hi there, I'm interested in the job and can help get it done quickly as required. Feel free to contact me and discuss more details. Best Regards, VL
Your brief is clear. I will build a script in VBA to do this. It will be perfect if you could just attach a sample file, one of your csv's.
I have 5 years of experience with VBA Excel. I have vast experience working with CSV. I can do this job instantly. Kindly share the files. Looking for your response.
Having two+ year experience in data management in excel using lots of vb scripts. I believe I can make/ reformat your vb scripts to fulfill your requirement.
I have good knowledge in Excel programming. Had completed 'n' number of projects. I am sure, I can complete this project within 7 days
Hi, Client I saw your outline. I understood your need. It would be good for you to send me your requirement more detail. Contact me and we can get started right away
One of my long term clients often provides me with a zip file containing hundreds of Excel files, which require data extraction and consolidation on a common Excel based platform. I see many similarities to the work yo 기타