VBA Macro Adjustment

Closed

Hello,

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

nagybatonyi

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)
5.6
Teloquence

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

$74 USD in 0 days
(70 Reviews)
5.6
mrbrave

Excel VBA expert available to start project immediately.

$64 USD in 100 days
(81 Reviews)
5.4
sonarkaushik

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)
5.0
priyal1997

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

$70 USD in 3 days
(25 Reviews)
4.5
nayabsiddiqi

can provide you the quality solution.

$66 USD in 0 days
(11 Reviews)
4.2
vikashgadia

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

$61 USD in 0 days
(15 Reviews)
3.6
adim

More than 15 years experience in Excel and VBA.

$111 USD in 3 days
(6 Reviews)
3.4
SoftwareEng8876

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)
3.0
drevak

VBA expert here.

$147 USD in 7 days
(2 Reviews)
2.9
paris2785

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

$98 USD in 7 days
(2 Reviews)
2.6
vaibhav585

Let me handle this for you !!

$105 USD in 1 day
(5 Reviews)
2.5
brymcgowan

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

$77 USD in 2 days
(0 Reviews)
0.0
DennisW1284

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

$55 USD in 1 day
(0 Reviews)
0.0
CARLOSHUGGINS

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)
0.0