Selecting a value from a dropdown list (data validation) which will populate cells..

**milkychips** · 11-07-2012, 01:23 PM

Hi Excel Forum.

I am attempting to create something (not sure if I need VBA) linking my database of football players to the Football Lineups spreadsheet attached.

=Starting Lineup!C1 has a dropdown with various football formations lists (G1:G17)

What I would like to happen is this -
Selecting a value in C1 will find the formation from the second sheet (Formations), copying the exact values into the grid between cells A1:E13 on the first sheet. This in turn will create a further dropdown on each of the 11 positions on the Starting Lineup sheet, which I will link to my database allowing me to select players for each position.

So, for example, selecting 4411 from =Starting Lineup!C1
will populate the sheet as follows;
ST which is in =Formations!U17 will appear in ='Starting Lineup'!C3
AMC which is in =Formations!U19 will appear in ='Starting Lineup'!C5
etc etc

And then - how do I create a new dropdown from these populated cells in A1:E13 which will allow me to link it to my database of players

**micope21** · 11-08-2012, 06:55 AM

Hi

Welcome to the forum

Please click on attachment workbook.

I add other sheet (Database) how it work with dropdowm with this formula in Starting Lineup cell B2

Formula:

Please Login or Register  to view this content.

Then copy cross and down
Column A hide them..

**milkychips** · 11-08-2012, 11:30 AM

micope21 thank you very very much indeed, that is exactly what I was after, and I am very grateful.

Could you shed any light on the next bit?

And then - how do I create a new dropdown from these populated cells in A1:E13 which will allow me to link it to my database of players

I have attached the updated workbook with a list of Players.

Selecting a team ='Starting Lineup'!B1 for example Atalanta
and a formation ='Starting Lineup'!D1 442

I am hoping to be able to select players listed for Atalanta (I think this might need a VLOOKUP) =Players!A5:A31 for each of the positions, so ST ='Starting Lineup'!C3 GK ='Starting Lineup'!D13 etc etc giving me something like the attached screenshot where a few players have been selected.

**micope21** · 11-09-2012, 09:07 PM

Hi

Please click on attachment.

Player name done.

Hope this solved it.

Selecting a value from a dropdown list (data validation) which will populate cells..

LinkBack

Thread Tools

Rate This Thread

Display

Selecting a value from a dropdown list (data validation) which will populate cells..

Re: Selecting a value from a dropdown list (data validation) which will populate cells..

Re: Selecting a value from a dropdown list (data validation) which will populate cells..

Re: Selecting a value from a dropdown list (data validation) which will populate cells..

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions