VBA Macro Adjustment

  • Status Closed
  • Budget $30 - $250 USD
  • Total Bids 15

Project Description


Here is what I need

On the file attached there is a tab called opcion A. That tab has a macro that puts information onto the template in that tab. The macro is triggered when a date range is changed on cell A2 and then it inserts Jobs information onto the template sorted by job due date (Column BJ)

This is what I need :

1. We need to move the Job Due Date Column before the "Generar Conduce" task Column. So in between columns AZ and BA.


2. We need to separate jobs by Job Due Dates(column BK) per week. Every week goes from Monday to Sunday. I think the only day that we need to check is the Job Due Date of the first Job so that we know where to throw that first division--just in case that first day is not a monday. After that it's simply checking for Job Due Dates from Monday to Sunday and throwing weekly divisions. The program should have a clear visible division between each week of Job Due Dates. It could be a colored row in between each week, but there has to be something that clearly shows the user weekly divisions.


3. Finally, we need to add up all the Job Estimated Revenue(found on column BK) totals for each week and post them on a different column on the same row where we are making the weekly division. So weekly division row in addition to having something visible to mark it as a division it will also include only one value which is the total Job Estimated Revenue for that week. This value will be on a new column at the end of the template called Job Weekly Estimated Revenue.


All these requirments can be seen in the attached file. I've even added the extra column plus a dummy numbers for the added Estimated Revenue for the first couple of weeks. The second file names Macro Template contains the macro in the same tab but with comments for better understanding.

Let me know if you can do this and for how much. Thank you for your time.

Get free quotes for a project like this
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