Completed

Log Working Hours into an already created Dynamic Calendar

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

Skills: Data Entry, Data Processing, Excel, Visual Basic

See more: working hours component joomla, log work hours, joomla working hours, toggl, free timekeeping software, timecamp, best time tracking software, employee time tracking software, dynamic calendar excel, free time tracking software, free timesheet software, working hours illustrator, working hours counter, working hours sri lanka, dynamic calendar net, working hours graphic designer, work log sheet hours employee date, working hours time counter, indesign count working hours

About the Employer:
( 37 reviews ) MALAGA, Australia

Project ID: #20072475

Awarded to:

sloker18

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 t More

$150 AUD in 3 days
(82 Reviews)
5.8

6 freelancers are bidding on average $108 for this job

elqueabandona

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 proje More

$200 AUD in 7 days
(226 Reviews)
6.9
dvcontact

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 More

$200 AUD in 7 days
(49 Reviews)
6.3
Davidpatric03

l am an expert in Microsoft word excel and other data entering works. My working speed is super and I do my best to the proposal I am engaged with. I can complete your proposal on time and hope you will enjoy working w More

$30 AUD in 2 days
(0 Reviews)
0.0
kashmirmzd60

Hi Dear Sir i am ready and interested to work on your project please hire me thanks...............................................................................................i am work on your project till your sanc More

$35 AUD in 1 day
(0 Reviews)
0.0
Nosratabouhamzeh

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 tea More

$30 AUD in 1 day
(0 Reviews)
0.0