Hello,
My name is John and I manage a cusotmer service call center. I have an attendance workbook that compiles all the scheduled time off for each rep through a vlookup formula. Each rep has their own attendance spreadsheet and when another one of the assistant managers wants to see who is off that day they just look on the "master" sheet. I am trying to figure out a way that I can create a worksheet that tells me the names of the people out on any given day.
My master workbook has two tabs "Scheduled" and "Unscheduled". Here is basically how the master works:
1/1/12 1/2/12 1/3/12
John Doe 8.00
Jane Doe 8.00
Jim Doe 8.00
Jan Doe 8.00
I want to have a sheet that tells me that on 1/2/12 Jane and Jim are off. I want to be able to do this without having to look manually. Is this somethign that can be done?
My name is John and I manage a cusotmer service call center. I have an attendance workbook that compiles all the scheduled time off for each rep through a vlookup formula. Each rep has their own attendance spreadsheet and when another one of the assistant managers wants to see who is off that day they just look on the "master" sheet. I am trying to figure out a way that I can create a worksheet that tells me the names of the people out on any given day.
My master workbook has two tabs "Scheduled" and "Unscheduled". Here is basically how the master works:
1/1/12 1/2/12 1/3/12
John Doe 8.00
Jane Doe 8.00
Jim Doe 8.00
Jan Doe 8.00
I want to have a sheet that tells me that on 1/2/12 Jane and Jim are off. I want to be able to do this without having to look manually. Is this somethign that can be done?