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.
18 freelancers are bidding on average $96 for this job
HI there. I am currently working on VBA macros in excel. I shall be glad to do one of yours too. I recently finished 2 similar projects for a US client. You shall be highly satisfied with the results. Regards