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.
To best illustrate your desire, please attach a small sample dummy workbook with data equivalent to what you have and what you want.
HTH
Regards, Jeff
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..
Last edited by vamshi4happy; 06-21-2011 at 08:13 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...
Please Login or Register to view this content.
Thank you Very much....I will definitely go ahead and use your suggestions...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks