View Single Post
 
Old 03-04-2025, 02:03 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
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

Instead of adding new sheets every month, and updating reports every time, I'd advice more database-like approach, with all tasks registered in single table, and getting the summary info from specific year, month, or even week using report sheets, where you select the report period, and wanted info is returned (in any format you like it) from data entry sheet.

Added is an example file for data entry (I entered data from 2 weeks from 2 different months).
Attached Files
File Type: xlsx TaskInfo.xlsx (28.2 KB, 6 views)
Reply With Quote