Looking to Make an automated Excel Calendar (est. 1h work)

Закрыт

Описание

Hello, i'm looking for someone who can automate some things for me on my calendar from work.

I tried it myself and i think its 80% finished but it's not properly done i assume since i have no knowledge of VBA, i used custom functions in VBA to achieve what i wanted, but somehwere along the line i got stuck so need someone to redo it.

Information:

So i want if i fill in a certain code on a certain day during the year(12 sheets jan--dec), that it automatically sets the proper code from that person in the proper cell on his personal sheet(sheet 13). These codes can also be divided into hours, so if a person takes 2hours off it should also show on his personal sheet in the proper cell but add up until it reaches 8hours(which is a full workday).

Example:

In example1 you have 4 days in january where the first person takes vacation. (2h A2, 3h A2, A2, A2).

Which means the first day he takes 2 hours A2, to go home sooner, the 2nd day he takes 3hours A2, the 3rd and 4th day he takes the entire day A2(8 hours).

Now in example2 i want this to reflect like so in A there should be a comment or note adding all the hours until it reaches 8 hours. So it should state in 2 lines

"2h A2 - 01/01"

"3h A2 - 02/01"

then it should continue to B which should state 03/01 and C 04/01.

So if the person takes 3h A2 on the 5th of january it should add it back to A, and because it has reached 8hours, it should continue from then on in an empty field again.

This should work for all codes(even future ones), so i wrote my code something like

vacation("1", "A2", "7") 1 was so the function knew which field it was to give me a value for it, A2 was the code it needed to look for, and 7 was in this case the row number for the person it had to look trough. But you are free to do what you like.

I hope this is clear, if you have any questions please ask. Its not very hard or alot of work, as me a very basic guy was almost able to complete this but the hours are a tad to hard for me, the days worked though.

Also please do not make it run the entire excel file for every sheet of vacation available to search for a code as we have 12 people and 12 sheets and it would just be slow as hell i think.

Would be best to run it only once(the entire 12 months) and put everythign in an array and then able to read it or something with a function.

Unfortunatly i cannot share you the file nor the code i wrote for it as its from my work and offcourse protected from bringing anything home with me. So i'll have to do it with 2 screenshots. You do not have to recreate the design but if the fields match and the code works i should be able to just copy it over to my working sheet.

Kind regards

Навыки: Ввод данных, Обработка данных, Excel, Visual Basic

Показать больше: automated excel shift roster, multiple graph creation automated excel, access creating work schedule calendar, work schedule calendar template, automated excel graph vba, automated excel forms, macros work excel internet, aspnet exmple work google calendar, automated excel graph, macro dont work excel 2000, freelance work excel vba, track work excel, automated excel roster, macros written excel 2000 work excel 2007, contract work excel access, excel 2000 macros work excel 2007, automated excel email, article submission work excel, show project work excel, work excel file, contract work excel, online contract work excel, automated excel sheet, automated excel, data entry work excel

ID проекта: #12139309

Поручено:

Topfreelancer4

Feel fee to contact me for.Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the clients.Make payment only after the work done.Thank yo Больше

€30 EUR за 1 день
(8 отзывов(-а) )
3.6

3 фрилансеров(-а) подали заявки на эту работу; средняя заявка - €25

TopExpertTeam

Dear Sir / Medam hope you will be fine We have over 16 years experience and 43 developers I read your descriton make sure what exactly you looking for and your project is completely simple and easy task for us to comp Больше

€55 EUR за 4 дней(-я)
(0 отзывов(-а))
0.0
€23 EUR за 1 день
(0 отзывов(-а))
0.0
MPLSW

I am having enough experience in design,search engine optimization, Data Entry, Web scraping etc. This is the project what I was really looking for.I strongly believe I deserve a chance for this project. I am new he Больше

€30 EUR за 1 день
(0 отзывов(-а))
0.0
€34 EUR за 1 день
(0 отзывов(-а))
0.0
shantanucse

Hello Sir, Currently i'm working on an e-commerce website as a Category Manager in Bangladesh. Previously I worked on another e-commerce website and uploaded their products on website. I worked there about 2 years. Больше

€23 EUR за 1 день
(0 отзывов(-а))
0.0