Employee performance details soon after they enter ID.

**vamshi4happy** · 06-20-2011, 08:49 PM

Hi friends,

I am seriously working on to learn and do a job in excel to collate complete data of employees and publish it to them..

All the employees are having performance metrics in different worksheets like CSAT , ASA AHT etc.. now I want to create a sheet, where when an employee enters his employee id, soon he/she can be able to see list of values of metrics in regards to the person in the same sheet.

Can anyone help me in guiding me and what exactly I need to know.

**jeffreybrown** · 06-20-2011, 09:28 PM

To best illustrate your desire, please attach a small sample dummy workbook with data equivalent to what you have and what you want.

**vamshi4happy** · 06-21-2011, 08:10 PM

Thank you Jeffery...I worked out and now able to work on my excel sheet using IF and Vlookup functions. However having problem in small task, I am attaching a sample excel. I need to write a formula so that when we open excel sheet it automatically should show the names of agents who's birthday falls on that particular day...there 100's of agents but for example purpose I put few names in excel...Please do advise me, it will be great help...

Thank you.... Vamshi..

**jeffreybrown** · 06-21-2011, 10:56 PM

Why not just use an autofilter and filter the list to view birthday's with today's date.

I'm not sure how to get those values into the box, but again, I believe a filter is the best way to go.

If you want to run the autofilter on open then in the worksheet module try...

Private Sub Workbook_Open()
    Dim ws As Worksheet
    Set ws = Sheets("Sheet1")
    With ws.Range("D8", Range("D" & Rows.Count).End(xlUp))
        .AutoFilter field:=1, Criteria1:=Date
    End With
End Sub