I am creating a spread sheet to show who is at work and who is off during the week. Not only may people be at work or off all day, they may also be at work or off part day. I have to account for 20 people, for 6 days and for about 100 different reasons. A formula would be very long and time consuming, this I could do if excel will allow me 100 reasons.
I need to fill in a cell with their start time, a cell with their finish time and a 3rd cell with what they are doing. sick, holiday, training are 3 examples of why someone may not be at work. each reason for not being at work is represented by a 2 letter code. the code could be in one of two cells for each person. my finished sheet is sheet1, the source of information is sheet2. all data on sheet 2 gets deleted each time the user does what they want and then pastes new date in next time. its always pasted in the same place and same format
what is the best way of doing this, formula, vlookup other?
I cant do vlook up so if this is the way to go I will need to learn this so pointers to training would be appreciated.
I have attached a spread sheet for a Monday to give some idea, hope it is of help.
thank you smiler44
I need to fill in a cell with their start time, a cell with their finish time and a 3rd cell with what they are doing. sick, holiday, training are 3 examples of why someone may not be at work. each reason for not being at work is represented by a 2 letter code. the code could be in one of two cells for each person. my finished sheet is sheet1, the source of information is sheet2. all data on sheet 2 gets deleted each time the user does what they want and then pastes new date in next time. its always pasted in the same place and same format
what is the best way of doing this, formula, vlookup other?
I cant do vlook up so if this is the way to go I will need to learn this so pointers to training would be appreciated.
I have attached a spread sheet for a Monday to give some idea, hope it is of help.
thank you smiler44