View Single Post
 
Old 05-21-2018, 03:59 AM
MILADREZAEE MILADREZAEE is offline Windows 10 Office 2016
Novice
 
Join Date: May 2018
Posts: 5
MILADREZAEE is on a distinguished road
Default

Quote:
Originally Posted by ArviLaanemets View Post
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.
this method is so tricky, I looking the way which when operator entry new data to a table, summary and all related table automaticaly updated
Reply With Quote