Update dropdown list based on previous selections

Hi DILIPandey,

Thanks for responding.

The drop down would be used in every cell under the columns headed "Week 1", "Week 2", "Week 3" etc etc... but as the Weeks go by, the previously used teams by a player cannot be used again, until such a time that all teams have been used at least once.

I have updated the Excel sheet so that the cells under the column heading "Week 1" all use drop downs which contain the selectable teams. Dependent on the teams selected in each cell, then the drop downs list in the other columns would list remaining teams yet to be selected by the player.

Regards

darthlawb