Hello Everyone,
Here's what i am trying to do.. I work in a call center and for every team leader i need to show their stats on a month by month basis. So.. i want a create a drop down list on a sheet where if they choose "Jan" and "Andy" only Andy's stats would display for the month of January.. His stats are broken up into month in Sheet 2. So in the sample workbook that i have provided, sheet 1 is going to be the view i want them to see. sheet 2 is the stat of 1 team leader (each tl would have their own sheet with stats for jan - dec) and sheet 3 is the link sheet (where i have all the tl names and month for the drop down). I have no idea how to go about doing this.
Can we combine drop down lists and vlookup somehow?
Any help would be appreciated.
Bookmarks