Hi,
On a worksheet I have 3 seperate ranges (J9:J28, U9:U28, J36:J55 = total 60 cells) where users can select from a drop down box either Y or N to poulate an indivudual cell.
I would like to have a limit of 30 Y's within the 60 cells. If someone would try and enter another Y after 30, this...