Find Jobs
Hire Freelancers

Log Working Hours into an already created Dynamic Calendar

$30-250 AUD

Completed
Posted almost 5 years ago

$30-250 AUD

Paid on delivery
I already have a Dynamic Calendar in excel where the user can select a month and a year and the calendar updates the days for that month in that year accrodingly what I need is for the user to double click on one of the days of the month and a userform will apear the Userform needs to have the following options Casual Labour Hire Name - This field to be a dropdown for the user to select from a list of names - Also need an option to add new names to the list so when a new name is added it can be selected from the list - Also need an option to remove the user from the list so its is not included in the list (however any logged hours for the user removed from the list remains - the option to remove the name is to only remove it from the drop down list) The list of names is to be available in every month and year - and any names added or removed from the list is therefore reflected no mater what month or year the user is looking at Hours Worked - This is so the user can enter in how many hours that user worked for that day Sales or Warehouse - This to be another drop down that the user selects either W for warehouse or S for Sales If the user selects a name for a day where hours are already logged it pre-populates the other fields (i.e. hours worked and Sales of warehouse that was keyed in previously) and the user can then update the hours worked if required or can delete the hours worked - (incase the entry was a mistake) As the names and hours are logged into each day of the calendar the names and their total hours worked for that month are then listed and summed below - if the user was to double click on a day in the month and sees the entries looged for that particular day the user can delete the hours logged so that it removes that entry for that person and therefore updates the list below The data entered needs to be saved so the user can toggle between the months and see what was logged - and be able to add and remove and also update names and their hours and the list below for that month updates accordingly Finally an email macro button to email the dynamic list below the calendar listing the names and summed hours worked for the month
Project ID: 20072475

About the project

4 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
With respect to this project I would like to present myself as a candidate for your consideration. I am proficient with Microsoft Excel and macro/VBA development. I read your project descriptions carefully. I checked the attached workbook as well… I can write the macro as requested. Kindly get back to me if you wish to proceed. I am available to start your project immediately. Looking forward to discuss further and work on your project.
$150 AUD in 3 days
5.0 (108 reviews)
6.3
6.3
4 freelancers are bidding on average $145 AUD for this job
User Avatar
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. It is a complex project that requires time and dedication. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
$200 AUD in 7 days
4.9 (248 reviews)
7.0
7.0
User Avatar
Hi, Would you like to see a quick demo of your project on modifying your Excel Dynamic Calendar to feature a user form that will be opened by double-clicking a day in the calendar completed before you award the project? You can consider it professionally done in less than 24 hrs. Rather than just show you past similar projects, I want to exceed your expectations by completing a part of your job as a FREE sample before you award the project. If you are satisfied with the result, you can go ahead and award the project. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks.
$200 AUD in 7 days
4.9 (58 reviews)
6.5
6.5
User Avatar
Hello dear sir/madam I’m a new freelancer and I ready to do your project right now faster than usual and carefully. I have validation method to deliver my projects to the best quality. I work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. It is a complex project that requires time and dedication. Best regards
$30 AUD in 1 day
5.0 (3 reviews)
1.7
1.7

About the client

Flag of AUSTRALIA
MALAGA, Australia
5.0
38
Payment method verified
Member since Nov 1, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.