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 In
3 days
Total Bids
Project Description

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.


Completed by:
Skills Required

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online