Macro or what?
Posted by Cliff on November 23, 2001 7:42 PM
I have a problem that seemed easy when I started out. I have a workbook that contains employee absences and deviations, my problem is that I need to know which employee was out for what day. It goes as follows....
Sheet 1 Absence Codes
Sheet 2 January. List of 40 employees and 31 days. Each day that the employee was absence will have a code. LOA, UA (Unexcused Absence), DA (Doctor's Appointment), etc.
On sheet 1, I want to pull each employee and the date they were out and the reason. If it doesn't make sense, email me and I will send a sample. Thanks for any help you can offer.
Posted by Tom Urtis on November 23, 2001 8:44 PM
Wouldn't an AutoFilter do what you want? Just use the employee name as the criteria and you will get all the absences on record for that employee.
Or, if as you say you want to know which employee was out for what absence reason, you might try sorting your list by employee name (primary), and absence code (secondary), and then subtotal the list, with at each change in employee name, using the Count feature for the absence code reasons.
But maybe there's more to your situation than that, so repost if these suggestions don't suffice.
Tom Urtis
