Hi guys,
I've done this before with no problems but can't for the life in me think about how I did it.
In cell A2 I have a drop down list of group names. When I select a group I want A3 to A10 to list the names in that group that are all in another tab.
So if A2 says "Football"
A3 to A10 returns 7 footballers names automatically
But A2 then changes to "Rugby"
A3 to A10 returns 7 rugby players
What do I need to do?
Thanks,
I've done this before with no problems but can't for the life in me think about how I did it.
In cell A2 I have a drop down list of group names. When I select a group I want A3 to A10 to list the names in that group that are all in another tab.
So if A2 says "Football"
A3 to A10 returns 7 footballers names automatically
But A2 then changes to "Rugby"
A3 to A10 returns 7 rugby players
What do I need to do?
Thanks,