Excel:how can i copy list of names from one worksheet to another?

Question

I have several worksheets with lists of players names (one sheet one team with 15 names). Each worksheet has name of one team. On one sheet named x*x i have drop down list with teams names. So how list of players can be copied from one sheet to x*x if condition is team name choosen from drop down list. For example when i choose on drop down list team name CCC i want names from that team to be written bellow. thanks for any help!

Answer 1

Here's a demo http://www.freewebs.com/swhtam/YA/teamPl...

Alt+F11, left side double click icon Sheet1(x*x) on the left, on the right side the code is all it takes to attain the goal.

To use the code, click the x*x sheet in VBA editor of your workbook, copy over the code, change the 1st 3 lines of code regarding cell locations, then you're done.

Please contact for more info.