Double Booking

A

Anthony192

Hi all,

I need to create a validation to prevent double bookings and have no idea
how. Any ideas would be very welcomed.

Regards

Anthony
 
N

NBVC

If your entry cells are A1:A100, then select them and go t
Data|Validation

Select Custom from the Allow menu and enter formula

=Countif($A$1:$A$100,$A1)=1 adjusting range to match your selectio
and where $A1 is the top most cell in your selection.

Now, if an entry is made more than once within that range, an erro
will pop up.

You can edit the error message and any input messages to coincid
through Data Validation also

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com
 
Top