Hello all. I have yet another issue with some Excel functions. What i need to do it pull the entire list of reps by their ID from the Team Rep List By Month file for any given month selected in cell L1 on Stars By Month By Team file. If you look at the red text in the file, (starting at cell W24:AB37) you can see the format im trying to get.

The idea behind this is, sometimes reps change teams different months. I know there is a way to do it, I'm just having a brain fart!

Thanks in advance guys!

-Steve Stars by Month by Team 2012HELP.xlsTeam Rep List By MonthHELP.xls