I have made a validation in the bottom table so that if someones initials comes up twice in the same column a message will come up saying i am trying to double book this person, Which works well.
However when i want to book someone in for a week long i drag there cell with initials along the week, when i drag cells across the data validation does not work, it doesnt pick up if there initals have already been put in other cells in some of the same columns.
How do i fix this please??
plpl.png
Bookmarks