Hello,
I work as a call center manager and I am attempting to create all of my spreadsheets for the 2012. One thing I want to do this year is to have all of the spreadsheets feed into masters depending on the topic. I have a team of four managers who will be updating the spreadsheet regularly. I am having a problem getting started.
The first spreadsheet I am working on is an individual attendance spreadsheet for each employee, that would then read to a master spreadsheet which includes all the employees. I have set the master of with the dates (1/1/12-12/31/12) posted as columns and the employees (1-35) as rows. The individual worksheet utilizes a drop down menu for the dates that the employee have have missed work or was late. I need the data derived from the drop down menu to autopopulate in the correct date field on the master, while staying in the same row that corresponds with the person who is being referenced.
I work as a call center manager and I am attempting to create all of my spreadsheets for the 2012. One thing I want to do this year is to have all of the spreadsheets feed into masters depending on the topic. I have a team of four managers who will be updating the spreadsheet regularly. I am having a problem getting started.
The first spreadsheet I am working on is an individual attendance spreadsheet for each employee, that would then read to a master spreadsheet which includes all the employees. I have set the master of with the dates (1/1/12-12/31/12) posted as columns and the employees (1-35) as rows. The individual worksheet utilizes a drop down menu for the dates that the employee have have missed work or was late. I need the data derived from the drop down menu to autopopulate in the correct date field on the master, while staying in the same row that corresponds with the person who is being referenced.