stirlingmw
Board Regular
- Joined
- Feb 18, 2013
- Messages
- 75
I have a spreadsheet with all my employees name in Column A and initials in column B (this is important as I have employees with the same last name. The rest of the spreadsheet is set out like a calendar, with row 1 being the month, row 2 been the day and then row 3 been the day of month 1st, 2nd, 3rd etc.
I use this spreadsheet to monitor the activities of my employees by blocking out days they are doing activities. Fore instance if Mr Brown is on holiday from the 13 Sep 14 to 20 Sep 14 I would shade the blocks on the 13 to 20th Blue so on so forth, different colours for different tasks.
periodically I need to be able to tell who is in the building at any one time, I can do this quite easily if the cells had something in them like a letter or number, but not just with the colour. I have a couple of queries.
Firstly
Is there anything I can program into the spreadsheet which allows me to add activities without having to scroll to the individual in the list and the scroll across to the correct date. I am thinking something like a control button labelled "Add Activity" with coding that opens a message box (not sure if this is the right type of object) which has a drop down box that allows you to select the person you require to add an activity to, a "Date From" box,a Date To" box, a drop down menu with the activities you can select from and finally an OK and Cancel button, Ok to add the selected activity to the spreadsheet and Cancel to return to the spreadsheet without adding info.
Secondly
I would like another Spreadsheet to calculate the numbers of employees doing a certain activity on a certain date. So the date would be input by myself and then maybe a drop down menu of the activity I wish to calculate for.
I hope I have explained this in enough detail. I have tried all sorts of spreadsheet designs but cannot come up with anything myself.
Many thanks for your time.
Steve
I use this spreadsheet to monitor the activities of my employees by blocking out days they are doing activities. Fore instance if Mr Brown is on holiday from the 13 Sep 14 to 20 Sep 14 I would shade the blocks on the 13 to 20th Blue so on so forth, different colours for different tasks.
periodically I need to be able to tell who is in the building at any one time, I can do this quite easily if the cells had something in them like a letter or number, but not just with the colour. I have a couple of queries.
Firstly
Is there anything I can program into the spreadsheet which allows me to add activities without having to scroll to the individual in the list and the scroll across to the correct date. I am thinking something like a control button labelled "Add Activity" with coding that opens a message box (not sure if this is the right type of object) which has a drop down box that allows you to select the person you require to add an activity to, a "Date From" box,a Date To" box, a drop down menu with the activities you can select from and finally an OK and Cancel button, Ok to add the selected activity to the spreadsheet and Cancel to return to the spreadsheet without adding info.
Secondly
I would like another Spreadsheet to calculate the numbers of employees doing a certain activity on a certain date. So the date would be input by myself and then maybe a drop down menu of the activity I wish to calculate for.
I hope I have explained this in enough detail. I have tried all sorts of spreadsheet designs but cannot come up with anything myself.
Many thanks for your time.
Steve
