I am attempting to make a vacation calendar.
I am looking to take a date cell and check if it is within a user entered date range. If so, I want it to return and concatenate all employees that were on vacation for that day. I am having 2 main issues. I cannot seem to place a criteria to only pull vacation that is not cancelled and I cannot seem to create a formula that will match the criteria and concatenate all returned values. However, I am leaning towards removing the cancellation entry type and instead just deleting/ altering entries whenever a cancellation request is made.
I have attached a document that resembles what I am working on. Ideally, this will allow the user to select the month on the calendar and it will be updated automatically with data pulled from the Vac Days sheet (Vacation table). The calendar 2 sheet shows what I envision, ideally.
I am open to any and all suggestion as I have been beating my head against this project for a few days. Also, I am not against VBA, but consider myself green and learning.
Thanks!
Vacation.xlsm
Bookmarks