Excel Macros / Visual Basic Coding
This project was successfully completed by FSchnabel for $60 USD in 3 days.Get free quotes for a project like this
Project Budget$30 - $250 USD
Completed In3 days
Our print company utilizes a material resource plan excel sheet in order to plan our paper ordering for a week at a time. I get raw data from a software we use to track our current jobs in house, what type of paper they run on and how much we need. The excel sheet we copy this raw data to has 3 macros attached to it and it does contain Visual Basic. The issue we are encountering is that, once the macro was run, an employee saved over the blank template document and unfortunately there is not a backup. I can supply the 3 macros (to best of my knowledge), a sample of the raw data, what I currently get when i input the raw data and run the macro (which is incorrect) and what the sheet is supposed to look like. We've tried to fix ourselves, and the macro does run, but it does not copy over how much paper we have in inventory (from raw data) and subtract how much is needed for jobs in house and leave me with a subtotal per paper type. Your job would be to fix the macro so the end result would be as sample provided after running macro.
We can use team-viewer so I can explain more in-depth once and illustrate what needs to be done.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online