how to copy the formula

1) On the Daily report, I've searched and cannot find your non-working INDIRECT() formulas. I also do not see on that sheet the cells that have the sheet names you would want.

Post #2 demonstrated the layout. Somewhere on the sheet is the tab name, then that tabname is used in the INDIRECT() to construct the formula.

BUT... I have to say, why bother? This appears to be a static layout of 31 days for a month's worth of data. Your formulas as laid out currently on the Daily Report are done, they should just work from now on.


2) You can simplify your formula on the day sheets.

C45: =COUNTIF(C2:C40, A45)
D45: =SUMIF(C2:C40, A45, F2:F40)
E45: =SUMIF(C2:C40, A45,G2:G40)