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 98 times
0
Phani
- 5,319
- 6
- 35
- 43
ezeagwulae
- 289
- 7
- 22
-
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