Linking data in worksheets in the same workbook

[CharDibbo]

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

[ChemistB]

Here is a solution using Array formulas (They must be entered with CNTRL SHFT ENTER instead of ENTER. If properly done, you'll see brackets around the formulas {})

With data in A2:B20 of sheet Master! and with Division name in A1 of each worksheet

Please Login or Register  to view this content.

copied down, see example.
Does that work for you?