Excel VBA Automation Needed -- 2
Budget: $10 – $30 USD
I'm looking for an expert in VBA and macros to help streamline my processes in Excel.
Key Requirements:
Shifts: Defined two shifts in the "task tap":
Morning: 6:00 to 15:30
Afternoon: 14:00 to 22:30
Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number
Delays: Ensured delays are reflected as discussed.
Task Order: Arranged tasks in the "task tap" from oldest to newest.
Please review the file and let me know if you have any questions or require further changes.
Requirements:
1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, the color of the cell will be changed to yellow, and a notification window come up and ask for the reason of the completion date change , and later the reason will be come up automatically if the reader put the browser in that cell when the planner assign task to dates ( start or end or arrange of days that are not working days like Weekends and National vacations) , then he get a popup notification inform him that this the task will run in non working days or the task will start in off days , and ask if you want to continue with the same dates . if he will continue then another window will ask for how many hours to consider as overtime and for who.
2- Need proposal to link each task with its list of material and in case there is a lack of the material the task should be highlighted in red or yellow, Red color mean material will not be available in the scheduled time and yello means the material will be available before starting the task .
3-There is 2 Major files like this , one for morning shift and the second for Afternoon shift , its required to merge them in one file and adjust the task duration to be in hours not days Starting from 00:00 up to 23:59 (24 hours )
Key Requirements:
Shifts: Defined two shifts in the "task tap":
Morning: 6:00 to 15:30
Afternoon: 14:00 to 22:30
Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number
Delays: Ensured delays are reflected as discussed.
Task Order: Arranged tasks in the "task tap" from oldest to newest.
Please review the file and let me know if you have any questions or require further changes.
Requirements:
1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, the color of the cell will be changed to yellow, and a notification window come up and ask for the reason of the completion date change , and later the reason will be come up automatically if the reader put the browser in that cell when the planner assign task to dates ( start or end or arrange of days that are not working days like Weekends and National vacations) , then he get a popup notification inform him that this the task will run in non working days or the task will start in off days , and ask if you want to continue with the same dates . if he will continue then another window will ask for how many hours to consider as overtime and for who.
2- Need proposal to link each task with its list of material and in case there is a lack of the material the task should be highlighted in red or yellow, Red color mean material will not be available in the scheduled time and yello means the material will be available before starting the task .
3-There is 2 Major files like this , one for morning shift and the second for Afternoon shift , its required to merge them in one file and adjust the task duration to be in hours not days Starting from 00:00 up to 23:59 (24 hours )