Find Jobs
Hire Freelancers

Log Working Hours into an already created Dynamic Calendar

$30-250 AUD

已完成
已发布将近 5 年前

$30-250 AUD

货到付款
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
项目 ID: 20072475

关于此项目

4提案
远程项目
活跃5 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在3天之内
5.0 (108条评论)
6.3
6.3
4威客以平均价$145 AUD来参与此工作竞价
用户头像
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 在7天之内
4.9 (248条评论)
7.0
7.0
用户头像
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 在7天之内
4.9 (58条评论)
6.5
6.5
用户头像
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 在1天之内
5.0 (3条评论)
1.7
1.7

关于客户

AUSTRALIA的国旗
MALAGA, Australia
5.0
38
付款方式已验证
会员自11月 1, 2013起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。