I need help writing a code for a work template. A macro that does a Countifs with dynamic ranges based on cell value:
Countifs($H$5:$H$?,$K5,$I$5:$I:$?,N$4)
"**?**" is dynamic based on the value of cell **L5**
Asked
Active
Viewed 91 times
0
Phani
- 5,129
- 6
- 34
- 42
ezeagwulae
- 279
- 7
- 18
-
Look [here](http://stackoverflow.com/questions/11169445/error-in-finding-last-used-cell-in-vba) for a good start. – Scott Craner Oct 01 '15 at 18:55
-
rephrased the question. – Phani Oct 01 '15 at 20:10