Excel VBA Automation Needed -- 2
$10-30 USD
Paid on delivery
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 )
Project ID: #38078015
About the project
18 freelancers are bidding on average $24 for this job
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look More
Hi there! I have expertise in this domain. Client's satisfaction is my first priority and believe in long-term relationship with clients. Please communicate to discuss in details. Thank you..
Hey Rayan, I have carefully read through the project requirements for Excel VBA automation. My expertise in VBA and macros allows me to streamline processes efficiently in Excel. To address the key requirements outli More
Hello, Kindly consider initiating a CHAT to transform your aspirations into tangible reality, as I am eager to delve into the intricacies of your project and collaborate effectively to achieve your desired outcome. For More
With experience in Excel VBA and formulas, I am more than capable of streamlining your processes to improve efficiency and reduce manual efforts for the two shifts. I am adept at organizing tasks based on their urgency More
Hai Rayan, Saya telah membaca dengan cermat persyaratan proyek untuk otomatisasi Excel VBA. Keahlian saya dalam VBA dan makro memungkinkan saya mengarahkan proses secara efisien di Excel. Untuk persyaratan memenuhi uta More
Hello Rayan G., I am Shahzaib, with 5+ years of experience in VB.NET, Visual Basic, and Visual Basic for Apps. I have carefully read the project requirements and propose to streamline your Excel processes by implemen More
Ampla experiência em automação de processos e facilidade com desenvolvimento em Visual basic Studio.
Dear , I am thrilled to submit my proposal for streamlining your processes in Excel using VBA and macros. With my expertise in Excel automation, I am confident in delivering solutions that meet your requirements. Key More
i can operate excel very great, i can code, and I'm able to cooperate with any project you have, i hope we can work together!
Experience data analyst can work your task easily. You can send the more details on my profile as i'm well-boss with advanced excel and VBA,
Hi, I would like you to work on your project. I am having around 15+ years of experience in BFSI domain. I am an automation Specialist in BI domain (BI reporting, Automation and Visualization). Can do programming in More
I am writing to express my interest in the Excel VBA Automation Specialist a robust background in data management and process optimization, coupled with my expert-level proficiency in Excel VBA, I am excited about the More
