Quote:
Originally Posted by ArviLaanemets
1. The formulas in 4 columns on sheet 2017 (H1...H4) meant to be hidden must have an additional check. P.e.
Code:
IF(OR(ROW()=EVEN(ROW());$G6<>"In Prog");0;COUNTIF($G$5:$G6;"In Prog"))
2. The names CntCompleted, CntInProg, CntNA and CntPending I created based on your example are non-dynamic currently. Change the last row number in formula from 21 to 29 (or redesign these names as dynamic ones.
3. In Report sheet, all formulas referred to ranges like '2017'!$A$6:$A$21 or '2017'!$L$6:$L$21. Change the last row number from 21 to 29 (or use dynamic ranges instead). |
1-
I tried to use this code but I got error ... 
Sorry maybe I missed something
2-
I have changed it to 45 because I added more rows
and it still the same thing ...
3- CntCompleted, CntInProg, CntNA and CntPending to make dynamic ??
Do you mean to make it as a drop-down list like the original words
- In Progress
- Pending
- Completed
- Not Assign
the file is attached ... Sorry for bothering you guys
