Hello, i've asked everyone i know about how to do this that uses Excel in my workplace and even browsed around looking for the answer, guess the best bet is to ask here, so thanks in advance for your time.

I am having some time and attendance issues where people are coming in 15-20 minutes late and i have to dive into Kronos for every employee to monitor it, i instead wanted to take a week spread of my employees start time vs. actual time and monitor it for 15,30,60,90 days.

I am trying to create several spread sheets for time and attendance. First i would have 20+ employees with their own spread sheet(named by name). I wanted to be able to take our one schedule for the week and simply paste it into a separate workbook(named Schedule). This schedule contains all of our employees in one quick easy to read format that is always the same, just different names and start times and the big issue is they are never alphabetical or anything, they can pick whatever schedule they want for the week based on seniority. By simply pasting that information into that workbook, i wanted the 20+ employee files to a) find their name, b) copy their schedule into their file, c) for the 2 days they are off, i wanted excel to show me that they are off d) take their start time for the days they work and put it in a cell (its a restaurant business, so their schedule has 'b' for breakfast, 'L' for lunch, 'D' for dinner)

example

Joe Cruz

11/11/11 b
11/12/11 b
11/15/11 b/l
11/16/11 l
11/17/11 d

Sue Shaw

11/12/11 d
11/13/11 l
11/15/11 b
11/16/11 b
11/17/11 b

I know for a fact i cant link my Kronos time keeping to the excel work sheet, but i wanted to be able to take a simply copy paste from Kronos with their actual times and paste it into a work book, then the actual times get put in a designated place in their designated files. This format would always be the same.

I have the employee file already saved with all of the dates for November in it, 1st through 30th.

So again for example, i take the schedule for the week and paste it into excel workbook file schedule. It has 20 employees names on it and their schedule. I wanted excel to find "Joe Cruz" out of that spread sheet. I then wanted it to import that schedule into that employees file. I thought it'd be a simple =if command, but it is not.

Again thanks for your time, not too sure if it makes complete sense, and its hard to search for something like this online. I'll monitor this often to make sure i eliminate any confusion.