Excuse me, theres actually a slight error in the code I just posted.

The 'StartAt' statement should read:

StartAt = HotelBooking.Cells(Rows.Count, "N").End(xlUp).Row