Booking system

[_Gandour_]

Hey guys, first time posting, straight from work.

My boss wants me to elaborate a conference room booking system for events at the office, right away i saw that it could not be done only through formula, so i broke the immaginary wall and started messing with macros for the first time.

Here is what i managed to do so far: A table in wich you can select the room and the date through a dropdown list as well as other information. If local and date are not equal to previous entries, it copies the information to another sheet ("Database")

But thing is i dont know hot to do whats next.

I made this stupid calendar besides the table:

print.png

What i want to do is that when i select the local through the drop down list it runs a macro that looks for Local (A:A) and Date (B:B) in the Database sheet and highlight on the calendar the dates in wich the rooms are occupied.

Do u guys have any idea how can i do that?

OBS:Besides showing only day numbers inside the cell because of formating, the cells actually contain the date in dd/mm/yyyy format.

[AlphaFrog]

Try something like this (not tested)

Please Login or Register  to view this content.

[_Gandour_]

Strangely, nothing really happens, not even an error message

[AlphaFrog]

Strangely, nothing really happens, not even an error message

Can you attach an example workbook.

[_Gandour_]

Can you attach an example workbook.

Here it is

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

[_Gandour_]

Wow, that works, thank you so much!!!

Just made a little change so it would clear the filter and not interfere with other macros.

Please Login or Register  to view this content.

[AlphaFrog]

You're welcome.

Put headers in row 1 of the Database sheet. The .Autofilter assumes the top row of the filter range is a header.

[_Gandour_]

If Anyone wonders how i was able to use the dropdown as the macro activator: here it is (Dont know if its the best way)

Please Login or Register  to view this content.

[_Gandour_]

You're welcome.

Put headers in row 1 of the Database sheet. The .Autofilter assumes the top row of the filter range is a header.

Yeah, did that. Thanks

[AlphaFrog]

If Anyone wonders how i was able to use the dropdown as the macro activator: here it is (Dont know if its the best way)

Please Login or Register  to view this content.

The Data Validation only allows a cell value from the list. This should work as well (not tested).

Please Login or Register  to view this content.