Finishing 85% complete project about automated Excel Calendar

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.

Skills: Data Entry, Data Processing, Excel, Visual Basic

See more: macros work excel internet, excel automated project, macro dont work excel 2000, freelance work excel vba, excel customer satisfaction project survey, converting excel visual basic project, excel database codes project, import excel columns microsoft project, excel automated project visual basic mechanical engineering, excel engineering design project management, track work excel, pregnancy calendar world project, macros written excel 2000 work excel 2007, excel macro protect project, google calendar integration project management, contract work excel access, excel 2000 macros work excel 2007, free excel template building project budget, find project complete, article submission work excel, show project work excel, work excel file, contract work excel, online contract work excel, data entry work excel

About the Employer:
( 2 reviews ) Evergem, Belgium

Project ID: #12240224

Awarded to:


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 More

€12 EUR in 1 day
(24 Reviews)

11 freelancers are bidding on average €41 for this job

€50 EUR in 2 days
(382 Reviews)

Hello. I have made many automated Excel calendars. I can help you to finish this. Let me know. Thanks..

€105 EUR in 2 days
(118 Reviews)

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 290 projects. Plea More

€70 EUR in 5 days
(161 Reviews)

Hello, I am proficient with Excel and VBA and I would love to help you with this projects. Please contact me for more information.

€28 EUR in 1 day
(84 Reviews)

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.

€29 EUR in 2 days
(54 Reviews)

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 75 projects, almost 70+ are complex VB/VBA/.Net/Webscrapping projects, hence i ca More

€30 EUR in 1 day
(70 Reviews)

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!

€40 EUR in 1 day
(76 Reviews)

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 More

€30 EUR in 1 day
(74 Reviews)

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 More

€30 EUR in 1 day
(35 Reviews)

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 More

€19 EUR in 1 day
(10 Reviews)

Hello Sir/Madam, Greetings for the day ! We would love to get involved in this project. We offer excellent services in web and data entry operations with following skill-set. 1. Data Entry 2. Data Proce More

€23 EUR in 1 day
(12 Reviews)