Hello all, last August i got some great help with a spreadsheet i was doing for my cricket association. Further to the sheet I'd like to improve on it and have come across a minor problem.
Now the Name range for the Green and Orange highlighted cells well on there own, reading the name, no problem.
My question is, is that I'd like to select the 'Season' drop down first, then the 'Grade' drop down second where the possible cells are narrowed down.
You will notice that Peter has 2 rows of data for 2018/19 season and 1 for 2019/20. I would like to select Cell P10 and select "Season" 2019/20 and only have one possible drop down in cell O10.
Can this be done?
As always, Thanks in advance
Bookmarks