Using Excel for a booking System?

Originally Posted by Leith Ross

Hello Revolver,

I can write a macro to do this for you. I could also have the macro insert a cell comment with the name of the person who made the booking. That way when you place the cursor on a red cell (booked), the comment will be displayed telling you made the booking. If this a feature you would like to include, let me know and I'll add it.

Sincerely,
Leith Ross

That would be fantastic.

Thank you

Hello Revolver,

It has been one of those days. Every time I started working on this project, I would get interrupted. The attached workbook is modeled after your screen shot (hope I did it justice). You can fill down the cells as you need for each month. To activate a new booking or edit an existing one, Double Left Click the on a time. Test it out and let me know if it suites your needs.

Sincerely,
Leith Ross

Thank you sir, you are a true gent!

Hi again.

Is it possible to have more than one month on the system shall I have a different sheet for each month?

Is there a macro available so the bookings delete themselves after 12 months?

Thanks again.

Originally Posted by Revolver

Hi again.

Is it possible to have more than one month on the system shall I have a different sheet for each month?

Is there a macro available so the bookings delete themselves after 12 months?

Thanks again.

Can anyone help?

One last bump.