|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#2
03-04-2025, 02:03 AM
|
|||
|
|||
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). 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need to match values in one column to values in six others and return the value of a cell from corre | SnakeDoctor | Excel | 4 | 09-09-2024 12:55 PM |
| Can Excel find Duplicate entries when only part of the cell's data is a duplicate of another cell? | jsisley | Excel | 1 | 07-21-2017 09:20 AM |
| Duplicate entries | yourforester | Outlook | 1 | 11-15-2014 10:44 PM |
 Reference another workbook and return values from the same cell across multiple sheets/tabs
|
lwls | Excel Programming | 5 | 11-08-2014 02:11 PM |
| Duplicating entries on multiple tabs automatically | jbexley | Excel | 0 | 08-28-2014 04:48 PM |
Windows 8 
Office 2016
Threaded Mode