I have a master registration file for a sports club with the names of each member (listed alphabetically) and the divisions they are playing in listed in one worksheet and then the individual divisions and team player names listed in another worksheet. If the player changes divisions, I would like to be able to change the division on the master registration file and have that name appear in a list of that particular team in the other worksheet.
How do I do this?
Thanks
Bookmarks