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.
Bookmarks