R
Riptide
I am trying to create a workbook for a fantasy Hockey league I am in. Here
is what I am trying to do. I have a validation on Sheet 1 in cell A6 which
indicates the players position (LW, RW, C, D, G). My LW's are located on
sheet 2 and Goalies on sheet 3. Once I choose a players position in cell A6
on sheet 1, I want to then have a validation or list in B6 which tells excel,
Look for all players on Sheet 2 from cell A1 to A100. The idea is that once
I select a players postion I can then go to cell B6 and see an entire list of
players that play LW. Likewise, if I were to select the G position it will
give me a list of all the goalies on sheet 3 and so on. Is this possible? It
just reduces the time it takes to insert each name at a time.
Thank you,
is what I am trying to do. I have a validation on Sheet 1 in cell A6 which
indicates the players position (LW, RW, C, D, G). My LW's are located on
sheet 2 and Goalies on sheet 3. Once I choose a players position in cell A6
on sheet 1, I want to then have a validation or list in B6 which tells excel,
Look for all players on Sheet 2 from cell A1 to A100. The idea is that once
I select a players postion I can then go to cell B6 and see an entire list of
players that play LW. Likewise, if I were to select the G position it will
give me a list of all the goalies on sheet 3 and so on. Is this possible? It
just reduces the time it takes to insert each name at a time.
Thank you,