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.
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).
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.