https://www.dropbox.com/s/twnxj476ocg334x/track.xlsx
In this file, I need to be able to select an employee in the "Time off sheet" tab and put in the date they took off of work. From there, I need it to fill in the output tab.
Issue being, I need to be able to track in the "Output" tab all the dates they took off in the "Time off sheet" in a single cell, based on when they took it off. Example: say employee J takes January 3rd 4th and 5th off, I need the cell in the output sheet to list 1/3 and 1/4 in the cell for row employee J and column week ending 1/4, and the have 1/5 go in the cell for week ending 1/11
I've been playing in VBA, but thats not really my area of expertise and I am not quite sure what type of formatting I would need to use to get the names and dates to match up. I considered a pivot table, but again I have minimal experience in that area as well.
Bookmarks