View Single Post
 
Old 05-21-2018, 02:42 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

In attachment is a version, where:
All attendancy entries are done in same sheet;
(As result), you can have any number of months without redesigning the workbook;
Summary is done on sheet Employees (you can have separate Report sheet, but this don't add any functionality, and adds complexity to design);
You can summarize any number of months, selecting start and end months for report period on sheet Employees.
Attached Files
File Type: xlsx Consolidate.xlsx (23.2 KB, 18 views)
Reply With Quote