Find Jobs
Hire Freelancers

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

€8-30 EUR

Terminado
Publicado hace más de 7 años

€8-30 EUR

Pagado a la entrega
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
ID del proyecto: 12139309

Información sobre el proyecto

3 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Feel fee to contact me [login to view URL] me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [login to view URL] payment only after the work [login to view URL] you
€30 EUR en 1 día
4,8 (8 comentarios)
3,6
3,6
3 freelancers están ofertando un promedio de €25 EUR por este trabajo
Avatar del usuario
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. So, I can easily do your tasks what you needed. I also know how to upload massive products via .CSV file through Seller Center or BOB. If you have more queries, feel free to contact with me. . Thanks Shantanu Sarkar
€23 EUR en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 here, but you know one thing? Sharks are born swimming. Get your project done within time.
€30 EUR en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 complete is successfully I am sure and hope fully you will hire us for your future projects once i complete your current project we are 43 developers doing web developent ,Mobile Applications development and SEO experts . ---------------------------------- Our Service Highlights- ---------------------------------- E- Commerce Website Development Php Msql Website Development iPhone - iPad and Android Apps Development Specialized Open Source Developers Php ,Css Ajax ,Jquery Website Development Magento Website Development Joomla Website Development Wordpress Website Development CSS ,Html,Html5 Web designing Respnsive Website Development Dynomic Website Development Static Website Development Web Pages Designing Digital Marketing including SEO and SEM SKILLS ======>>>> PHP, MySQL, HTML, CSS, JavaScript, JQuery, Wordpress, Front End Development, ASP .NET, C#, Ajax, C++, SQL Server, Content Strategy, Functional Scope, Illustration, Information Architecture, Interaction Design, Mobile App Design, Project Management. Plz Come to live Chat to help you i am waiting for you on live chat thanks
€55 EUR en 4 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de BELGIUM
Evergem, Belgium
5,0
2
Forma de pago verificada
Miembro desde nov 20, 2016

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.