Auto populate multiple rows from a drop down list
<p>I have been searching the internet for hours and can find nothing to answer my question so I thought I would try here in the hope that someone can point me in the right direction. Here is what I am trying to accomplish:...</p>

<p>I am building a self-calculating score sheet for my local Darts League. The sheet is just about finished except for the team data.</p>

<p><em>Example:</em>
I have a dropdown list in cell <strong>A4</strong> which contains the 8 teams in my division</p>

<p>The list is populated through data validation from another sheet. This other sheet also contains 8 columns (1 for each team) containing the names of the players in that team. Each column is named for the team.</p>

<p>I want to be able to select a team from the list in <strong>A4</strong> and automatically have their players inserted into cells <strong>A24</strong> thru <strong>A36</strong>.</p>

<p>If anyone has any idea how to do this or knows of a tutorial to get me started, it would be greatly appreciated.</p>

<p>Thanks to all who reply.</p>

<p>I need to make a correction in the explanation above... I should have realized the mistakes before post... I apologize</p>

<ol>
<li>The drop downs are in cell A5 for the home team and K5 for the Away Team</li>
<li>The drop downs contents are on second sheet named 'Teams'</li>
<li>The players content is on sheet 3 named 'Players' with the team names as headers in the first row.</li>
</ol>

<p>I have attached a copy of the worksheet filled in manually to show what I want to do, which is the populate rows 58 to 69 in columns A and I according to the team selected in the drop downs.</p>

<p>I'm pulling my hair out with this one.!</p>

<p>Thanks again.<a href="https://www.dropbox.com/s/ndl0ntkxic39xe0/SIDL-Scoresheet%28Self-Calculating%29.xlsx?dl=0" rel="nofollow">Download Worksheet from Dropbox</a></p>