Hi,
Im very new to Excel and was wondering is some was able to help with this question.
I have a Excel 2010 workbook used to rota in a large amount of staff for a call centre, which is split into four teams. Each sheet corresponds to a month of the calendar year eg Jan201, Feb 2014 etc..
What im trying to do is put in a sheet at the front of the workbook that I can select the team, which populates the list of staff in that team and then checking across a specified date range gives the shifts that those respective staff will be working for the set time period (probably be looking at a seven day period and a 1 month period). (This in turn will be printed out to give to the staff members.)
I have figured out how to auto populate the names and create a macro for the printing, but I cannot find a way to check the persons name and individual date to return the shift they are working.
I don't seem able to download the file for an example.
Thanks in advance.