VBA Macro Adjustment



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.

Skills: Excel, Visual Basic for Apps

See more: visual c# jobs, vba jobs, vba excel jobs, time in az, row 44, jobs vba excel, jobs in az, jobs excel vba, jobs az, jobs applications, excel macro how to, column jobs, ba jobs, az jobs, what is vba in excel, what is vba, what is macro in excel, visual jobs, vba time, vba day of week, me vba, excel mark, excel 2013 vba, end vba, jobs visual basic

Project ID: #4653871

13 freelancers are bidding on average $88 for this job


Such jobs are my daily practice. I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. Fixing of bugs and minor changes More

$155 USD in 3 days
(46 Reviews)

Consider it done. Check your PM for my bid details.

$74 USD in 0 days
(70 Reviews)

Excel VBA expert available to start project immediately.

$64 USD in 100 days
(81 Reviews)

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$73 USD in 3 days
(16 Reviews)

Dear Sir. Kindly check PM for my bid details. Thanks -Priyal

$70 USD in 3 days
(25 Reviews)

can provide you the quality solution.

$66 USD in 0 days
(11 Reviews)

excel vba expert.................. piece of cake............

$61 USD in 0 days
(15 Reviews)

More than 15 years experience in Excel and VBA.

$111 USD in 3 days
(6 Reviews)

Hello sir...i am very much interested in this project.i have to do my best to get good positive feedback from you.you can believe to get good results from me.just give me one chance to prove. Thank u!

$150 USD in 2 days
(2 Reviews)

VBA expert here.

$147 USD in 7 days
(2 Reviews)

VB and VBA expert for over a decade. Master in Information Systems.

$98 USD in 7 days
(2 Reviews)

Let me handle this for you !!

$105 USD in 1 day
(5 Reviews)

I'd be happy to help out and can turn it around quickly. I appreciate your consideration.

$77 USD in 2 days
(0 Reviews)

This is no problem at all. Let's get it done!

$55 USD in 1 day
(0 Reviews)

Hi I'm a VBA expert... I work with macros on a daily basis... I will deliver high quality results... Thanks for considering my proposal.... Tambien hablo español de repente asi es mas facil la comunicaion....

$90 USD in 5 days
(0 Reviews)