I have a worksheet that totals monthly productivity. Within this sheet I also subtotal each pay periods within that month. Currently I do this manually for each sheet. Is there a way to do it with VBA? For instance, Col D is my list of dates and Col K through Col AB are my employees. On row 120 is their monthly productivity numbers. Row 121 and Row 122 are their subtotals based off of pay periods, for example 4/1/22-4/15/22 and the next pay period is 4/16/22-4/30/22. Thanks in advance!