Hi
I have 4 sets of data that contain names of 4 different team members.
What I want to do is that when user selects TEAM A in the first list box the
2nd list box that has names of the team memebsr should show the names of the
TEAM A
The TEAM data is in cells
TEAM A A2:A16
TEAM B B2:B16
TEAM C C2: C16
TEAM D D2 to D16

Please advise how to write a VBA code and also where should this code be