Hi Steve
Please find herewith the update Workbook.
I have taken the liberty of adding a small piece of code that checks if a room number is already in use on the FRONT SHEET and blank the cell if it is until you correct the error.
If you need any further help then please let me know.
Good luck.
Tony
|