jbrown021286
Board Regular
- Joined
- Mar 13, 2023
- Messages
- 81
- Office Version
- 365
- Platform
- Windows
image 1
image 2
What i am wanting to do is pretty complex image 1 shows my source of aggregated data that is updated daily to fill in the dated columns. at the end of each month it is copied and pasted into the sheet of the corresponding month and kept for reference till the end of the year. what i want to do is add all the production numbers in each date column separated out using the employee numbers in column b into the tables in image 2. 1 being each employees total week to date starting on Sunday. 1 being each employees total year to date starting 1/1/24 and the last 1 being the total of a custom date range defined by the cells under start and end. Is such a complex task archivable?
image 2
