Hi
I have a workbook with 2 worksheets - (A & B)
Worksheet B holds a list of teams, I.e. Team 1 in Column A, Team 2 in Column B etc....
On worksheet A, in Cell A1, I have a drop-down with all the relevant teams on worksheet B
What I would like to do, is: If for example, Team 1 is chosen from the drop-down list, the user will then click a button to recover the team members in that team, however, they would need to put in a specific "password" (for that team - they will all have different), as long as the correct password is given, then the list of team members will populate Calls A5:A25 (20 members per team).
this should be pretty simple to do, however, my mind is a total blank as I've not done Macro's in a while
Thanks
MarkAn
I have a workbook with 2 worksheets - (A & B)
Worksheet B holds a list of teams, I.e. Team 1 in Column A, Team 2 in Column B etc....
On worksheet A, in Cell A1, I have a drop-down with all the relevant teams on worksheet B
What I would like to do, is: If for example, Team 1 is chosen from the drop-down list, the user will then click a button to recover the team members in that team, however, they would need to put in a specific "password" (for that team - they will all have different), as long as the correct password is given, then the list of team members will populate Calls A5:A25 (20 members per team).
this should be pretty simple to do, however, my mind is a total blank as I've not done Macro's in a while
Thanks
MarkAn