I'm attempting to complete a time off request book.
The user will enter name, type of request, and date(s) in the VBA form. The form will then list the requests in order separating single date requests from multiple. (Requests Sheet)
My problem comes in when I need to list all the requests by date (DATA Sheet). I've listed a sample of what i would like to see below each date but I cant figure it out. I've tried some index and array formulas but the closest I can get is listing of the first column in the whole array. I would like for a formula to look at all the information in (Requests Sheet K5:AT30) and return all requests that were made on the same day in the data sheet.
For example
6/1 6/2 Etc....
Req1 Req1
Req2
Req3
The data will then help populate the Calendar for viewing. (June 22)
I'm open to any ideas including a VBA option, or redoing the way I have the requests listed.
Any help would be appreciated.
Thanks!
Bookmarks