Finishing 85% complete project about automated Excel Calendar
€8-30 EUR
Pagado a la entrega
Keep in mind this project is 85% done, it was actually finished until i found it i needed to add 2 things more.
Basicaly i have an entire year for every employee of mine, if someone takes vacation it gets a certain code (A2 in the example) but it there are other codes to (A1, A5, etc etc).
If i put A2 in the month sheet(january in this case) that means that person takes off a whole day, which should automatically show up in their personal sheet under the tab A2 with the date that person took the A2(which is in the example).
Now if a person takes 4hours vacation( as seen on 6th and 7th of january) thats not an entire day so it adds the dates in a comment in the personal field.
This has all been done before by someone else and works.
The things i need done now(you can see [url removed, login to view]), is:
1. To add minutes to it. So not just hours but also minutes. An example would be "1u30 A2" or "4u45 A1".
2. If someone takes 5u A2 on day 1, 5u A2 on day 2 and 6u A2 on day 3, they now all get put in seperate cells on the personal sheet because it tries to add up to 8 and waits for 3u, 3u and 2u, but i can actually add 3u from day 2 to day 1 and add the 6u from day 3 to day 2. So its needs recalculating so it will always add up to 8hours.
3. You need to check in the Month sheets in the comments aswell(seen in [url removed, login to view]).
If a person takes 5u A2 and the field is to small i will add the other codes in a comment section on that date and i want them added to the comment section as we do now.
If you have any question please contact me.
It seems hard but it's quite easy to understand when you know what i mean.
Nº del proyecto: #12240224
Sobre el proyecto
Adjudicado a:
Hi Employer, I have total 6+ years of experience in excel VBA macro. I hope I should be able to complete your job. I have completed very similar projects in the past. Please let me know if interested. Thank Más
11 freelancers están ofertando un promedio de €41 por este trabajo
Hello. I have made many automated Excel calendars. I can help you to finish this. Let me know. Thanks..
Hello, I am proficient with Excel and VBA and I would love to help you with this projects. Please contact me for more information.
Hello, I am Excel and VBA expert. Can you provide the file? Please note that I have 100% completion rate and 5-star feedback on 50 projects.
Hello. 30 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Más
Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporti Más
I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. I am a financial engineering graduate and have extens Más
