Macro to do various steps

Hi and welcome to the forum.

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

I've uploaded a slimmed down version of what I have created and tried to explain in more detail below what I'm
hoping a couple of macros can do.

1. Person selects date they want to book a desk using the dropdown list to check if it's available.
A person's name in a cell means it's already booked - the desk reference visible (D01, D02, etc) means it's available.

2. Person scrolls down to book their desk by recording the desk reference number (cell Z44), the required date (cell Z48) and
their name (cell Z52) in the relevant fields. When the person records this information, a desk booking reference will
be generated in cell Z127.

3. When the BOOK button is clicked, a macro will:

a) check if any of the cells Z44, Z48 or Z52 are empty:

if YES message box "Please record all required fields"

if NO - then check if the booking reference in cell Z127 already exists in column A on the BOOKINGS tab:

if YES message box "Unfortunately, the desk you require is already booked for that date. Please choose a
different date or desk" and cells Z44 and Z48 will clear.

if NO - values in cells Z52 and Z59 will populate the next available row in columns A and B on the BOOKINGS tab and
a message box saying "Your booking reference is D01-260521. Please keep a note of this as you will need it should you
wish to cancel your booking"


When somebody wants to cancel their booking they record the booking reference (e.g. D01-260521) in cell BZ48 and click
the CANCEL button. This will find and delete the booking reference in column A and the corresponding name in column B.