VBA script for looping a row in excel csv file by varying amounts
- or -
Post a project like this3798
$$
- Posted:
- Proposals: 7
- Remote
- #360230
- Awarded
Excel Expert, Excel Spreadsheets, Excel VBA & Access Database Developer, Data modelling & Analysis
London
ASP.Net, C#, ASP, PHP, AngularJs, EF, LINQ, HTML, Javascript, VBScript, SQL server, Oracle, JQuery
Mumbai
354955066690327128912279300307865496988
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
We have a large database of replacement parts for cars. They are in alphabetical Manufacturers order. The part numbers are repetitious as they may fit different models, the important part for this project is the 'Manufactured Years - From' and the 'Manufactured Years - To' columns. We need some VBA script that will take the difference between the FROM and TO years and loop that row the appropriate number of times. The FROM and TO format is YYYYMM. If there is no year specified in the TO column it will still be a current production model and would therefore need the current year. The job is to enhance the search facility on our web site. We are a company that sell new in the box, quality replacement car parts and have been trading for 20 years.
Andrew R.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
18 Nov 2013
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies