On the worksheet "Leave Request" employee's can enter request for time off (vacation or whatever) of work. What I need is a macro that will sort the worksheet using two criterias, the first sort uses the column labeled "Start" and then by the column labeled "Requested".
The second thing I need is a bit more complex I think...I would like a userform that would allow you to see who's on leave on a specified date. For example if an employee wants to know if leave is available on September 5, 2008 they could pull up the userform and enter the date September 5, 2008 and the names of the employee's who have requested this day already would then be displayed in a message box or some other format. In this case using the names currently on the "Leave Request" worksheet the following names would appear 1. GG 2. EE 3. CC 4. BB Is this possible??? A problem I foresee is that the dates that have been requested and aren't listed individually????
Any help would be appreciated .
Best regards,
Charlie