I'm creating an attendance tracker based and I want to populate the cells in the Calendar tab with data from the Log tab.
Basically, in each cell, I want to return the code that matches both the date and the employee's name, if an entry for that employee on that date exists at all.
Sorry if I didn't explain very well - I've been fighting with Excel for 2 days and am not clear-minded at all when it comes to functions right now.
Bookmarks