I'm very new to this page, so first off I will introduce myself. My name is Matt and I been working with Microsoft Office for a few years now. I received my Masters Certificate about 6 months ago. I create a very in depth spreadsheet for Daily Fantasy Sports purposes. I create player projections, algorithms and player ratings.
I'm not sure if this topic is going to be posted in the right thread, I chose Excel general and not formulas because it technically isn't about formulas, but named ranges and drop down lists.
So like I just said, I create spreadsheets for Sports. The goal I am trying to achieve is creating a drop down list in Cell D4 for the Team names. Then when I select a team, it give me the players of the team starting in Cell D10... I have the player lists defined as a name range, and I have the list of teams defined as a name range as well. I can get the Drop Down list to give me the teams, But I just cant figure out how to be able to get the players inserted when I select the team name.
Any and all help is greatly appreciated...