Dropdown selection inserts certain text

Hi all,

I'm looking to see if it's possible to do the following:

I'd like to have a dropdown list (multiple, really) on one sheet that, upon a selection, calls and places text from another sheet into specific cells.

This is the context of my request: The sheet is a bunch of scorecards for a flag football league. I'd like to have dropdown lists of teams and when you select the team for the card, it inserts the team's roster from another worksheet onto the card.

Any help is appreciated -- much thanks.

I looked at that function and it seemed to be close, but I'll try to be a bit more specific to what I'm looking for.

Say on spreadsheet one there's a dropdown menu with "Team 1," "Team 2," and "Team 3."

On spreadsheet two, there's just a list of teams and players... like
...A.............B
Team 1......Joe S.
Team 1......Joe P.
Team 1......Joe Q.
Team 2......Mike A.
Team 2......Mike B.
Team 2......Mike C.

and so on...

So when the person selects "Team 1" from the dropdown, the macro/function/whatever places Joe S., Joe. P and Joe Q. in specified cells on spreadsheet one.

The idea would be to do this with the two teams playing eachother, so there'd be multiple dropdowns and multiple functions working to place these players in their respective spots.

I'm running Excel 2002, if that matters as well.

Thanks for your help.

i think you can use the choose function to do what you want, rather than try to explain i have attached a sample sheet that explains what to do

hopefully it will do what you want

regards
marc

That function seems to work just like I need... but one followup question: How can I change the formatting of the text within the drop down?

Thanks a bunch for the help

I ran into an issue with this procedure... it seems I have too many arguments for the choose function to work. I have it currently going from C:AE, but I need it to go to AL at the minimum.

Any ideas?

Much thanks