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.
13 freelancers are bidding on average $88 for this job
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!
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....